Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Any formulas to look up unsorted column ?
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 -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Any formulas to look up unsorted column ?
Try looking in the help index for VLOOKUP where it talks about FALSE
-- Don Guillett SalesAid Software "Mr. Low" wrote in message ... 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 -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |