Vlookup is giving #N/A
I have this formula in a spreadsheet and it's bring back the correct items needed. However, if there is nothing to bring back, I'm getting #N/A. I need it to bring back the correct $$ amount and if #N/A comes back, I need it to show as a $0.00 and not #N/A.
=VLOOKUP(B5,'Oct 15'!B:F,5,FALSE)
Can someone help me out?
|