I am attempting to look up (VLOOKUP) information using the results of an INDEX/MATCH formula which always results in a #NA result.
=VLOOKUP(INDEX(DATA1!$H$3:$H$270,MATCH(B4,DATA1!$M$3:$M$270,0)),DATA2!$A$2:$A$500,6,TRUE)
Alternatively, I have tried to break the formula into two stages, adding the formula below into E2
:
=INDEX(DATA1!$H$3:$H$270,MATCH(B4,DATA1!$M$3:$M$270,0)
and then in a separate field use the VLOOKUP formula referencing E2
:
=VLOOKUP(E2,DATA2!$A$2:$A$500,6,TRUE)
Is there any way I can complete this formula using the output from another formula?
update on my original question I am getting the value in E2 - I am trying to us the data calculated from that field to complete Vlookup but it doesn't work. When I try and use that data for the next formula which is =VLOOKUP(E2,DATA2!$A$2:$A$500,6,TRUE)I received #NA
E2
that you expect? If you rewrite the third formula with the value ofE2
plugged in as a constant, what happens? Please do not respond in comments; edit your question to make it clearer and more complete.VLOOKUP(
42
, DATA2!$A$2:$A$500, 6, TRUE)
fails (assuming that the value ofE2
is42
) — so that should be the focus of your question. If a formula fails when it stands by itself, it doesn’t make sense to worry about how to use a formula output as part of another formula. You might want to do some research on debugging, problem isolation, and simplification.