Using V&H LOOKUP With MATCH to find a value.

[clark05]

So, I'm not sure how to explain this, but I've been trying to use vlookup, hlookup, and match to grab information from the correct row.

I have a column with duplicate values and cannot seem to figure out how to differentiate between them.

Any help is greatly appreciated.

help.xlsx

[Søren Larsen]

Try this for max speed and adapt it for other returns:

Please Login or Register  to view this content.

[clark05]

Søren Larsen, you are my hero. Thank you!!!

[Søren Larsen]

You are so welcome!