vlookup... the other direction

[Andrew_Rossington]

I tried the normal Lookup function, but I can't sort my lookup column in ascending order due to the nature of my spreadsheet.

Is it possible to "vlookup" a value in column B and return the value from column A, for example?

 

[Andrew Poulsom]

You can use eg:

=INDEX(A:A,MATCH(C1,B:B,FALSE))

 

[Andrew_Rossington]

Thanks for your suggestion.

It's displaying #REF!

I think my forumla should look like this:

=INDEX(D7:G338,MATCH(E4,G7:G338,1))

Is it formatted correctly?

 

[Andrew Poulsom]

More like:

=INDEX(D7:D338,MATCH(E4,G7:G338,FALSE))

the FALSE argument is necessary for an exact match if your data is not sorted.

 

[Andrew_Rossington]

More like:

=INDEX(D7:D338,MATCH(E4,G7:G338,FALSE))

the FALSE argument is necessary for an exact match if your data is not sorted.

Marvelous! Thanks very much for your help squire.