Hi Everyone,
I need my VLOOKUP formulas in rows 5 and 6 of the "Cashflow" sheet to return a zero if there is no corresponding value or date in the table it looks to in the "Inputs" sheet.
Any help would be greatly appreciated.
Thanks in advance.PERE_Vlookup returning error.xlsx
I didn't download your file.
Try putting the VLOOKUP function inside an IFERROR function:
=IFERROR(VLOOKUP(...),0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
does that attachment work now?
The IFERROR didn't seem to work?
Works for me:
=IFERROR(-VLOOKUP(E$2,Inputs!$H$10:$I$14,2,0),0)
You have the cell formatted as Accounting which displays 0 as - (dash).
is it possible to include the -(dash) before it and get the outcome I need? You're right IFERROR works when the -(dash) is removed but i need accounting format
Maybe this...
=IFERROR(-VLOOKUP(E$2,Inputs!$H$10:$I$14,2,0),"0")
That will return 0 as a TEXT value. Since numeric 0 has no effect on a sum then a TEXT 0 will also have no effect in a SUM(...) formula.
that is working for me in row 5 but not in row 6 for some reason?
Like this...
=IFERROR(-VLOOKUP(E$2,Inputs!$B$6:$D$88,3,0)*Inputs!$I$18,"0")
But now your SUM function returns $ -.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks