10-Marble
August 17, 2024
Solved
Using vhlookup on a dataset for a vector
- August 17, 2024
- 1 reply
- 877 views
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.



