Page 1 of 1
Lukup
Posted: Tue Dec 17, 2024 10:17 am
by sna
hi there!
I need an excel formula to lookup value base on two criterias from a table
I attach a template
thanks
Re: Lukup
Posted: Tue Dec 17, 2024 1:28 pm
by 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
...
Re: Lukup
Posted: Tue Dec 17, 2024 8:31 pm
by sna
Thanks ,
and how about the below template for 3 criteria and expectation as in the template.
TY
Re: Lukup
Posted: Tue Dec 17, 2024 10:10 pm
by 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
...
Re: Lukup
Posted: Wed Dec 18, 2024 6:37 am
by sna
Sorry Only Sheet1
The criteria1 30000,criteria2 USD ,criteria3 24
So answer is under USD 18% ,KHR 18.5%
Re: Lukup
Posted: Wed Dec 18, 2024 7:14 am
by 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
Re: Lukup
Posted: Wed Dec 18, 2024 1:02 pm
by sna
thanks