View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pirate Pirate is offline
external usenet poster
 
Posts: 2
Default Lookup with multiple returns

I need to lookup a value in the second sheet and return multiple results to
the first sheet in a row.
Example:

Sheet 1

A1 B1 C1
D1
20003399 Result(sheet2 B1) Result(sheet2 B2) Result(sheet2 B3)


Sheet 2

A1 B1
20003399 Dog
A2
20003399 Cat
A3
20003399 Horse


Hope this makes sense.
--
Thanks,
Pirate