Lookup a value in a list and return multiple corresponding values in a column

[azkhan]

I am looking for a formula to lookup a value in sheet1 Column A and return multiple corresponding values in Column B. I have sheet1 that contains Account Names (A2 - A65736) and Product Codes (B2 - B65736) and Account Manager Names (C2 - C65736).

1. Accounts have more than 1 product code associated.
2. Account Managers handle more than 1 account.

In sheet2 I have a few accounts names (not all) and I am trying to index all product codes linked to it in sheet1.

Many thanks for your help.

 

[DILIPandey]

Hi Azkhan,

Can you show the sample data ?


Regards,
DILIPandey

 

[azkhan]

Hi Dilip, I have not found an option to attach a spreadsheet from my desktop. Please can you guide me how to do it. Thanks.

 

[krishna334]

Try a free online image uploader, take screen shots of your data and paste the links

 

[Skybluekid]

Look at this tip from Excel is Fun Channel this might help: Excel Magic Trick 616

Excel Magic Trick 616: LARGE & SMALL Functions (8 Examples) - YouTube

 

[Aladin Akyurek]

Hi Dilip, I have not found an option to attach a spreadsheet from my desktop. Please can you guide me how to do it. Thanks.

Try a metgod like Borders-Copy-Paste.

Also, have a look at:

http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354

for a solution set up if you want a multifield result list.