Hi, I've tried the following formulas and it either doesn't work or show error message of too many arguments. =IF(VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE)="","",VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE)) Formula still shows N/A when "a7" is blank I've tried =IF(INSA(VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE),0,VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE)) formula shows too many argument error message. I appreciate any help. Thank you,
Just check A7 first before you run any further calcs. =IF(A7="", "", IF(VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE)="","",VLOOKUP(A7,TEVA!$C$4:$O$352,13,FALSE)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks