Thread: Lookup Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kaye kaye is offline
external usenet poster
 
Posts: 5
Default Lookup Formula

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