Hi,

The range only needs to be sorted for nearest match. Try this

=VLOOKUP(B8,A1:C5,3,FALSE)

Mike

"AMSH" wrote:

Hey,

Can anybody tell me how to get around excel's requirement that the lookup
vector must have sorted data - if the data isn't sorted it returns an
incorrect value.

Example:
Column A contains: 1,2,3,4,5
Column B contains: 5 blank cells, 4,5,1,3,2
Column C contains: E,D,C,B,A

I want to lookup a cell in column B - B8 (1) in column A - A1 and return the
corresponding value in column C - C1.

Any ideas?

Many thanks,

AMSH