Silly question but I am trying to clean up my excel spreadsheets
For example I have a column which has the following formula "=IFERROR(VLOOKUP(B5,ResourceList,3,FALSE),"")". This works fine as when there is no value I have a perfectly blank cell
However, =IFERROR(((VLOOKUP(J$3,'Yearly Calender '!$B$6:$F$44,5,FALSE))*(J5*$I5)),"") Here I get a "$ -"
Even when I copy the formats, I still get an error. The format is a $ amount
The formula is returning "0".
I'm guessing that the value you have in J3 exists in the yearly calendar tab, but the cell in column F is blank, which means it returns "0".
The best workaround I can give you is:
=if(vlookup(J$3,'yearly calender '!$b$6:$f$44,5,false)="","",IFERROR(((VLOOKUP(J$3,'Yearly Calender '!$B$6:$F$44,5,FALSE))*(J5*$I5)),""))
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks