find data based NOT on the first column of my array

Hi,

I am trying to look for a value, x, which is located somewhere in my array Y of several rows and columns. Value x is located somewhere in column 4 in array Y. Once x is located i want to return the value in the same row as x but in column 1. It's kind off a reversal of your typical use of vlookup. Since vlookup can only be used when i'm looking for a value in column 1 (??) ("The value to be found in the first column of the array.") How can i do this?

If my question is unclear i attached a simple example workbook. I have colors "linked" to the number 1-10. I can easily find the color linked to a number (columns D and E) but how can I find the corresponding number to a color (space to solve in column H)

In H1 of that book and filled down..

=INDEX($A$1:$A$10,MATCH(G1,$B$1:$B$10,0))

Awesome! Thanks Jonmo1! Kind off weird how vlookup can't do this..

Great, glad to help.

Originally Posted by vizzkid

Awesome! Thanks Jonmo1! Kind off weird how vlookup can't do this..

Yep, Vlookup is Zoolander challenged.
But Index/Match is better anyway. Much more flexible.