Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value in table with multiple results
I have a table of names with corresponding amounts as follows:
Note: I prefer using functions and not code for this project. A B abc 1000 def 5000 ghi 3000 abc 4000 def 7000 abc 9000 Example: I need to retrieve all of the "abc" names and the amounts, and place the amounts in 3 consecutive cells, which correspond to "abc." The range is dynamic, with a maximum of 15 rows, 5 different names (in column A), and 3 amounts per name. Thank you in advance for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup a value in a table which has many results? | Excel Discussion (Misc queries) | |||
Lookup with multiple results | Excel Discussion (Misc queries) | |||
Lookup with Multiple results | Excel Worksheet Functions | |||
Lookup Returning Multiple Results | Excel Discussion (Misc queries) | |||
How can I do a lookup and get multiple row results? | Excel Worksheet Functions |