topic Using vhlookup on a dataset for a vector in Mathcad

Using vhlookup on a dataset for a vector

frederico.cms — Sat, 17 Aug 2024 18:28:40 GMT

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.

Re: Using vhlookup on a dataset for a vector

Werner_E — Sat, 17 Aug 2024 19:18:25 GMT

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

Re: Using vhlookup on a dataset for a vector

frederico.cms — Sat, 17 Aug 2024 19:37:01 GMT

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