Look ups

[will]

Hi,

Is there a look up function that doesn't require the table to be in
ascending order?

Thanks

Will

 

[akphidelt]

You can use VLOOKUP... make sure you use FALSE at the end.

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble