Lookup with Multiple Result

[UNNI NAIR]

Dear Friends,

Due to my bad English, I can't explain correctly.

In Attached file, H 12 entered the Apple, I need
all Apple - Customer name from C7 to C65,

This is a sample sheet. I have a Data more than
7500 Rows.

Thanks in advance.
Unni

[Glenn Kennedy]

Firstly, you need to change your thread title before help can be offered. Can I suggest "Lookup with multiple results". To change your title, select thread tools in the first post and it is in there somewhere.

Secondly, which Excel version are you using. Your profile (which also needs to be changed) does not say...

[AliGW]

As Glenn has said already, please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Almost everybody here wants a formula!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
  
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[samba_ravi]

J12

Please Login or Register  to view this content.

Try this and copy towards down
or use pivot table
see the attached file

[dominicb]

This thread has been closed.
Please see other thread.

https://www.excelforum.com/excel-gen...ml#post4967196

DominicB