Fetching multiple values using vlookup

[Ravi Dawar]

Hi All,

Is there a way to get multiple rows out of a vlookup function. E.g. the table I am looking into has more than one instance of the lookup value and those multiple instances have different values in the column I need as output.

What I want is to have all those output values. E.g. in the attached spreadsheet, in sheet 1, I want to retrieve all instances of promoA from sheet2.

Thanks.

 

[NARAYANK991]

Hi ,

The VLOOKUP function cannot be used to return multiple values , since it will always retrieve the first value which matches the lookup value.

If your data is sorted on the column which has the lookup value , you can use the VLOOKUP function to retrieve the first value , and then have another formula to retrieve the other values , as long as the lookup column has the lookup value.

If not , you will need to use the technique explained here :

http://chandoo.org/wp/2011/11/18/formula-forensics-003/

http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

Narayan

 

[JAMIR]

Hello Ravi

It is ok!

Regards,


Zameer