Hello team,
I have find out the a lookup value and return some value from column 6:
This is my data:
Plan diagCode Num1
AA HBC 12
AA CDC 13
I have to look into both columns: Plan and Diagcode. What formula founds the value of Num1 for Plan AA and DiagCode HBC?
XLookUP? SumProduct? Index and match?
Please advise me.
Respectfully,
Tea
How to find a LookUp value in 2 arrays and in certain columns?
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to find a LookUp value in 2 arrays and in certain columns?
Unless you show what the sheet looks like it is impossible to answer.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: How to find a LookUp value in 2 arrays and in certain columns?
I used this function:
INDEX(A1:G55,MATCH(1,(B:B=J2)*(C:C=J3),0),7)
I had two arrays:
Plan
measures
We wanted to look up values by looking up in this two arrays.
Regards,
VeryGreenTea.
INDEX(A1:G55,MATCH(1,(B:B=J2)*(C:C=J3),0),7)
I had two arrays:
Plan
measures
We wanted to look up values by looking up in this two arrays.
Regards,
VeryGreenTea.