LinkBack URL
About LinkBacks
The Vlookup function returns a n/a error if no lookup value is supplies, an various other errors when invalid keys are entered. How can I use a combinatation of at least three level of if functions to avoid these problems.
The Vlookup function returns a n/a error if no lookup value is supplies, an various other errors when invalid keys are entered. How can I use a combinatation of at least three level of if functions to avoid these problems.
will this do?
also use the $ around your vlookup otherwise your number will change
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Not sure if this is what you are looking for but you can try the following?
In Cells D23:D27
=IF(ISERROR(VLOOKUP(C23,Prices!$A$2:$C$32,3,FALSE)),"",VLOOKUP(C23,Prices!$A$2:$C$32,3,FALSE))
In Cells F23:F27
=IF(ISERROR(VLOOKUP(C23,Prices!$A$1:$E$32,5,FALSE)),"",VLOOKUP(23,Prices!$A$1:$E$32,5,FALSE))
In Cells G23:F27
=IF(F23="",0,E23*F23)
Last edited by Shannon561; 04-17-2015 at 02:09 AM.
What if I can't use IF(ISERROR. I need to use, ISBLANK, ISNONTEXT, IS NUMBER,ISTEXT.
I understand how to use IF(ISNA and that works but I cant use that one either.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks