Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a table where the lookup value appears multiple times .....
ie Table Looks like this Value Ref 3 A 5 Z 6 B 7 C 3 F 5 G With standard lookup functionality, If I looked-up value 3, I would bring back "A" I'd like a method where I can specify which occurence of "3" in the table it brings back data from. (ie to be able to do a lookup & specify to bring back data from the second record of "3" rather than the default first) Any Ideas ???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bring Back DBF! The GIS Industry uses it! | Excel Discussion (Misc queries) | |||
lookup to bring back multiple values | Excel Worksheet Functions | |||
How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO | Excel Worksheet Functions | |||
Bring Back Qualified Sum from another WB | Excel Worksheet Functions | |||
Using VLOOKUP,what if I have more than one occurence of my Lookup. | Excel Worksheet Functions |