Using vhlookup on a dataset for a vector

[frederico.cms]

Dear,

I have a dataset where the first column represents the index of a vector and column 2,3 and 4 the three possibilities. The first row contains the classification for a specific condition. The dataset has been manipulated to align these indices and classifications.

My vector, for example, have this format::

However, I'm having trouble getting the vertical-horizontal lookup (VHLOOKUP) to search for each element in my vector and correctly return the value at the intersection based on the classification assigned to each vector element. Anything I tried returned 3x1.

I have tried it all from the similar post:

https://community.ptc.com/t5/Mathcad/Use-vlookup-over-a-vector/td-p/482509

Prime 9 attached.

[Werner_E · Accepted solution]

Maybe you are looking for something like this:

Depending on your needs it could be convenient to turn it into a function

BTW, there seems to be no difference between "LOW" and "MEDIUM"

Prime 9 sheet attached

[frederico.cms]

I can't thank you enough, Werner. That was a brilliant solution.

I have to work much harder on programming, as it is compulsory for manipulating and extracting information from datasets.

By the way, the table is for a hazardous zone study IEC 60079-10-1.

Many thanks again.

Fred