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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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