what is wrong with this If Statement? thnak you

May 5, 2017 at 12:46:27
Specs: Windows 7
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))


See More: what is wrong with this If Statement? thnak you

Report •

#1
May 5, 2017 at 13:18:51
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 think I 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.


Report •
Related Solutions


Ask Question