I am trying to submit a multi if statement and vlookup. here is what I have but not working =IF(ISNA(VLOOKUP(C122,ProjectTracker!$A$1:$AV$118,3,FALSE)),IF(ISNA(VLOOKUP(C122,Planned!$A$1:$AV$118,3,FALSE)),IF(ISNA(VLOOKUP(C122,Complete!$A$1:$AV$118,3,FALSE)),IF(ISNA(VLOOKUP(C122,Cancelled!$A$1:$AV$118,3,FALSE)),”Not Found”,VLOOKUP(C122,Cancelled!$A$1:$AV$118,5,FALSE)),VLOOKUP(C122,Complete!$A$1:$AV$118,5,FALSE)),VLOOKUP(C122,Planned!$A$1:$AV$118,5,FALSE)),VLOOKUP(C122,'Project Tracker'!$A$1:$AV$118,5,FALSE))

re: "here is what I have but not working""Not working" does not give us much to go on. Since we don't have a copy of your workbook with all the various sheet names and data, we can't test your formula to any great extent.

What does "not working" mean? Does it not return what you expect? Does it return an error? Does it make smoke come out of your monitor?

P.S. I

thinkI know what's wrong, but I'll save my comments until you tell us what "not working" means. When posting in a help forum it's best that you provide as much information as possible so that we know know where to start looking for a solution. "My car's not working. What's wrong with it?" ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Slack's direct listing "IPO" is a good idea?

Discuss in The Lounge

Poll History