View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zakfalls zakfalls is offline
external usenet poster
 
Posts: 3
Default lookup to bring back multiple values

Hi,

I have a sheet with various names in column A with attributes in col B, the
names can occur more than once. a normal vlookup will only bring back the
first value in col B which i know. but i want to bring back all the different
result in column b for a name which occurs more than once.

I know this invloves Arrays, but the eg ive seen is set up in a way where
the name you are looking is on the first line, and amending it does not
really work for me.

Does anyone have any suggestion or a better example of how to do this?

hope ive made this clear!!!

Cheers