Forum Discussion
Solved
Need help with formula as not sure what am doing wrong
Could someone help please? The formula for column I is =IF(ISNA(VLOOKUP(H11,$Y$10:$Z$34,2,FALSE)),"",(VLOOKUP(H11,$Y$10:$Z$34,2,FALSE))) What I need and am struggling to work out is I need Column J...
As variant
in J =IFNA(VLOOKUP($I11,$Z$10:$AB$34,3,0),"") in E =IFNA(LOOKUP($H11,{0,4,8,15,21},$AB$38:$AB$42),"")
As variant
in J
=IFNA(VLOOKUP($I11,$Z$10:$AB$34,3,0),"")
in E
=IFNA(LOOKUP($H11,{0,4,8,15,21},$AB$38:$AB$42),"")
SergeiBaklan Hi Sergei, thanks for the reply. Unfortunately the formula provided for J did not work but the formula for E did work. Then I thought what if I recalculate the formula for J along similar lines to E but change the cell letter/number, and it worked so thanks for your assistance, my problem has been resolved.
Stephen
Stephen, glad to know you sorted this out, thank you for the feedback.