LOOKUP problem with non-sorted vector
With A1 thru C10 containing:
1
2
3
4
5
6 4 E
7 5 D
8 1 C
9 3 B
10 2 A
=VLOOKUP(A1,B1:C10,2,FALSE) will display C
The FALSE is important!
--
Gary''s Student - gsnu200814
"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
|