Populate data based on cell information

**famico78** · 04-04-2013, 07:23 AM

I have a cell (F11) which shows the name which is selected from a drop down box on sheet1.

In sheet2 I have a list of products which are categorised by the name/s which show in sheet1 (F11)

What I am trying to do is that when I select from my drop down list that all products from that category in sheet2 are shown in sheet1.

Please help!

**Pete_UK** · 04-04-2013, 07:50 AM

You would normally use VLOOKUP to do this, or an INDEX/MATCH combination, depending on how your data is set up. Post an example file if you need more detailed help.

Hope this helps.

Pete

**famico78** · 04-04-2013, 07:58 AM

test.xls

I have attached a test copy, thanks Pete.

**dilipandey** · 04-04-2013, 08:07 AM

Okay.... can you share a sample workbook ?

Regards,
DILIPandey
<click on below * if this helps>

**Pete_UK** · 04-04-2013, 08:07 AM

I'm just going out now, but if no-one else has responded by this evening then I'll get back to you.

Pete

**dilipandey** · 04-04-2013, 08:22 AM

Hi famico,

Try using below formula:-

Formula:

Please Login or Register  to view this content.

Enter with key combination : ctrl shift enter

see attached:- test.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**Pete_UK** · 04-04-2013, 06:11 PM

I see that DILIpandey has given you an array formula solution, but you've not marked this thread as solved so I've attached my approach, which uses helper columns. Just change the item using the drop-down to see the effects.

Hope this helps.

Pete