Look ups
 

Hi,

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

Thanks

Will

Look ups
 

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

Look ups
 

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