Get instant live Excel expert help and learn how to use an IF function with a VLOOKUP
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula that looks into an array and if in that array it has one of the following: TCO302, TCO332, TCO333, then it returns an X in that excel file. Below is the formula I am trying to make work:
=IFERROR(IF(N819="X","X",INDEX(Data!$N$2:$N$2000,MATCH(1,(Data!$B$2:$B$2000=B819)*(ISNUMBER(MATCH(Data!$I$2:$I$2000={"TCO302","TCO332","TCO333"},0))),0))),"")
My last gotitpro suggested the following formula but our time, time out:
:=IF(OR(VLOOKUP(B5,B122:I135,8,0)="TCO302",(VLOOKUP(B5,B122:I135,8,0)="TCO332")),"X","")
Solved by F. W. in 17 mins
DESCRIPTION:
=IF(ROWS(A$7:A7)<=$E$3,INDEX('ENTER DATA - PRODUCTION'!A$2:A$16732,SMALL(IF('ENTER DATA - PRODUCTION'!$B$2:$B$16732='DO NOT TOUCH - ARRAY FUNCTION'!$B$1,IF('ENTER DATA - PRODUCTION'!$J$2:$J$16732="B2",ROW('ENTER DATA - PRODUCTION'!$J$2:$J$16732)-ROW('ENTER DATA - PRODUCTION'!$J$1)+1)),ROWS(A$7:A7))),"") What is wrong with this formula. I'm using this for duplicate Vlookup function. I get #NUM! error.
Solved by B. Q. in 15 mins
Fixing Formulas
DESCRIPTION:
I need a formula that looks into an array and if in that array it has one of the following: TCO302, TCO332, TCO333, then it returns an X in that excel file. Below is the formula I am trying to make work: =IFERROR(IF(N819="X","X",INDEX(Data!$N$2:$N$2000,MATCH(1,(Data!$B$2:$B$2000=B819)*(ISNUMBER(MATCH(Data!$I$2:$I$2000={"TCO302","TCO332","TCO333"},0))),0))),"") My last gotitpro suggested the following formula but our time, time out: :=IF(OR(VLOOKUP(B5,B122:I135,8,0)="TCO302",(VLOOKUP(B5,B122:I135,8,0)="TCO332")),"X","")
Solved by K. J. in 11 mins