LookUP Referencing multiple columns

[Ecel Dumbo]

Hi Friends,

Could you please refer the attached file and suggest a lookup formula which need to reference values from two columns ? Thanks

 

[Nebu]

Hi:
You should actually match 3 columns to pull the data as you need , I have done a array formula to get the result Please find the attached.

 

[NARAYANK991]

Hi ,

Something like this.

Narayan

 

[Nebu]

Ignore my file I miss took your requirement with one other query....

 

[Ecel Dumbo]

Thank you very much Narayan. Exactly what i wanted

 

[jeffreyweir]

This is exactly the kind of think that PivotTables are good at. See attached.