Using VLOOKUP to return multiple results for the same lookup value

Hello all,

I am trying to use VLOOKUP to return multiple results for the same lookup value.

example:
column A______________Column B
Manufacturer__________Model
Ford_________________Escort
Jaguar_______________XJ220
Ford_________________Mondeo
Lotus________________Elan
Ford_________________Fiesta

What I need to do, using this as an example, is in a separate sheet locate all of the different Ford models available. Using Vlookup the only result I can for ford is the escort, not the escort, mondeo and fiesta. Rubbish example but I hope it makes sense?!?

Any help would be appreciated.

Thanks in advance,

Steve

Hi,

Have you tried to use Data Advanced Filter ...?

Hi,

See attached ...