Forum Discussion
Solved
vlookup + match
Hello. I need help with a formula combining vlookup and match. Somehow, the return is not correct. My formula right now is: VLOOKUP($B9,$B$2:$B$5,MATCH($A9,$A$2:$A$5,0),FALSE) But it's wrong ap...
=IFERROR(INDEX($I$9:$L$12,MATCH($H2,$H$9:$H$12,0),MATCH($G2,$I$8:$L$8,0)),"incorrect")
This returns the results for fruit and country however in the database there are no values for months. Therefore we can't include criteria for months in the formula.
This seems to work on the first example I provided. But how can I make the same criteria work when the data is built differently? I will attach an update.
=IFERROR(INDEX($I$9:$L$12,MATCH($H2,$H$9:$H$12,0),MATCH($G2,$I$8:$L$8,0)),"incorrect")
This returns the results for fruit and country however in the database there are no values for months. Therefore we can't include criteria for months in the formula.
- Thank you! It worked perfectly!