Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a Vlookup formula that looks in cell A1 (account #) on Tab A
and then goes to Tab B to find that account #. Tab B will have about 3000 lines of data and could include that account # as many as 30 times. When it finds each line with that account number I need it listed on Tab A. I can get it to copy the first time it finds that account # but how can I get it to list all the others on lines 2-31? Is there a way that all 30 lines can be listed on Tab A? Thanks -- Kaye |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to Lookup Min value | Excel Discussion (Misc queries) | |||
if v lookup formula | Excel Worksheet Functions | |||
Lookup Formula help | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
lookup formula help | Excel Worksheet Functions |