vlookup:how to get several results ?

[chum]

Hello,

I have used the vlookup formula to get the results of a tab into another one but sometimes there are several results. How can I do to see all these results ? I was thinking of an advanced filter but don't really know how to build it.
as you can see as per the attached excel file, in the first tab custA, I have 3 results for Microsoft: 'microsoft north', 'microsoft south' and 'microsoft eastern'. But as per my formula I only get 'microsoft north'.

thanks in advance for your help !
Chum

[Bryan Hessey]

Hello,

I have used the vlookup formula to get the results of a tab into another one but sometimes there are several results. How can I do to see all these results ? I was thinking of an advanced filter but don't really know how to build it.
as you can see as per the attached excel file, in the first tab custA, I have 3 results for Microsoft: 'microsoft north', 'microsoft south' and 'microsoft eastern'. But as per my formula I only get 'microsoft north'.

thanks in advance for your help !
Chum

Hi,

the attached I first saw posted by Carim, it should help you.

---

[chum]

Hi Brian,

thanks this is already a big help


Cheers,
Chum