Lukup

[sna]

hi there!
I need an excel formula to lookup value base on two criterias from a table

I attach a template

thanks

[norkaz]

...
Hi Guy

There are 2 sheets. Which sheet should I write the formula on?

However, I guess your requirement is like this.
If not, please provide an example answer for better understanding.

Sheet1
L7
=IFERROR(INDEX(INDEX($D$6:$I$13,0,MATCH($M$5,$D$4:$I$4)+($M$4="KHR")),ROWS($L$7:L7)),"")
Copy it down.

Sheet2
H3
=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(Div[Currency])/($H$1=Div[Currency])/($H$2=Div[Size]),ROWS($H$2:H2))),"")
Copy it down.

Bigcat9Excel
Bangkok Thailand
...

[sna]

Thanks ,
and how about the below template for 3 criteria and expectation as in the template.

TY

[norkaz]

...

Hi Guy,

I need help with some issues.

• For Sheet 1, for Term 24, where do the answers of 17% and 17.5% come from?

• For Worksheet D, please show the expected answers for clarity.

• And please remove the colors in the worksheet from the parts that are not related to the answers in both worksheets.



Bigcat9Excel
Bangkok Thailand

...

[sna]

Sorry Only Sheet1
The criteria1 30000,criteria2 USD ,criteria3 24
So answer is under USD 18% ,KHR 18.5%

[norkaz]

...

E22
=VLOOKUP($F19,$C$6:$I$13,MATCH($F$17,$C$4:$I$4,0),0)

F22
=VLOOKUP($F19,$C$6:$I$13,MATCH($F$17,$C$4:$I$4,0)+1,0)

Bigcat9Excel
BKK Thailand

[sna]

thanks