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