Lookup with Unsorted Data ?

[WP]

I am looking for a way to do a lookup on a range of data that cannot be
sorted for other reasons, or I prefer not to sort. I can find this
reference from M$

http://support.microsoft.com/?scid=.../servicedesks/bin/kbsearch.asp?article=181212

but I am wondering if anyone has anything "cleaner"...maybe a nice VBA
function for example.

Thanks

 

[RWN]

Actually you can use VLOOKUP with unsorted date by including the "False" "range_lookup" in
the statement.
=VLOOKUP(xx,xx:xx,x,FALSE)
See the help on the function for a full explanation.
"If range_lookup is FALSE, table_array does not need to be sorted."