Hi,

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

Thanks

Will

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

"will" wrote:

Hi,

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

Thanks

Will

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
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

will wrote:

Hi,

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

Thanks

Will

--

Dave Peterson