Lookup with multiple variable

[meami111]

I have the following sample database starting with A1 as the 1st column heading:
[TABLE="width: 452"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Colour[/TD]
[TD]Shape[/TD]
[TD]Taste[/TD]
[TD] Blank[/TD]
[TD]Colour[/TD]
[TD]Shape[/TD]
[TD]Taste[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Sphere[/TD]
[TD]Sweet[/TD]
[TD] [/TD]
[TD]Red[/TD]
[TD]Sphere[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Triangle[/TD]
[TD]Bitter[/TD]
[TD] [/TD]
[TD]Blue[/TD]
[TD]Triangle[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Square[/TD]
[TD]Hot[/TD]
[TD] [/TD]
[TD]Green[/TD]
[TD]Square[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Rectangle[/TD]
[TD]Tangy[/TD]
[TD] [/TD]
[TD]Yellow[/TD]
[TD]Rectangle[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Sphere[/TD]
[TD]Sweet[/TD]
[TD] [/TD]
[TD]Blue[/TD]
[TD]Sphere[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Triangle[/TD]
[TD]Bitter[/TD]
[TD] [/TD]
[TD]Green[/TD]
[TD]Triangle[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Sphere[/TD]
[TD]Hot[/TD]
[TD] [/TD]
[TD]Yellow[/TD]
[TD]Sphere[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Triangle[/TD]
[TD]Bitter[/TD]
[TD] [/TD]
[TD]Red[/TD]
[TD]Triangle[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Square[/TD]
[TD]Hot[/TD]
[TD] [/TD]
[TD]Blue[/TD]
[TD]Square[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Rectangle[/TD]
[TD]Tangy[/TD]
[TD] [/TD]
[TD]Green[/TD]
[TD]Rectangle[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

I want to find out the Lookup value for Taste in column G. Will sumproduct/sumifs work here? If not how can we get the look up value?

Thanks in advance for your help

 

[Aladin Akyurek]

In G2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($C$2:$C$11,MATCH($E2,IF($B$2:$B$11=$F2,$A$2:$A$11),0)),"no found")

 

[meami111]

Hi Aladin

Can you please tell what is to be done for the following instruction
"In G2 control+shift+enter, not just enter, and copy down"

I selected the G column with Ctrl+Shft+Enter and then pasted the formula in G2 and then again pressed Ctrl+Shft+Enter. It is copying the 1st result in all the rows.

Looking forward to your support

Thanks

 

[Aladin Akyurek]

Type the formula in G2. Then press down the control and the shift keys at the same time while you hit the enter key. If done correctly, Excel itself puts a pair of { and } around the formula in recognition.

 

[meami111]

Dear Aladin

Have tried put the array execution suggested by you. While it is working for other formulas, for the one suggested by you, I am only getting the first result repeated in all cells. Can you please check at your end if the desired result is coming?

Thanks

 

[Aladin Akyurek]

Dear Aladin

Have tried put the array execution suggested by you. While it is working for other formulas, for the one suggested by you, I am only getting the first result repeated in all cells. Can you please check at your end if the desired result is coming?

Thanks

See the workbook which implements the suggestion: Dropbox - meami111 Lookup with multiple variable.xlsx

 

[meami111]

See the workbook which implements the suggestion: Dropbox - meami111 Lookup with multiple variable.xlsx

Thanks a lot Aladin !! Issue resolved

Regards

 

[Aladin Akyurek]

Thanks a lot Aladin !! Issue resolved

Regards

You are welcome.