Excel 2002: Any formulas to look up unsorted column ?

[Guest]

Dear Sir,

I understand that VLOOKUP formula work very well on sorted column.

If I have unsorted column with blank spaces between rows in the lookup
table, Is there any formula suitable for looking up from this kind of table ?

Eample :


Items looking for:
Code Price
5008
4120
5120
8300


Lookup Table
A B C
1 Code Price
2 5121 24.00
3 5008 36.00
4 5160 22.00
5 5009 10.00
6 S.total 92.00
7 4120 51.00
8 6540 20.00
9 2263 10.00
10 8322 41.00
11 S. total 122.00


Thanks

Low

 

[Don Guillett]

Try looking in the help index for VLOOKUP where it talks about FALSE