Hi All,
The formula below does exactly what I want but I haven't been able to "wrap" it so that if either result ends in N/A or some other error the formula returns a blank/zero answer. I'm sure it's a simple error on my part so would appreciate any help 🙂
=IF(L$4>$D$1,(VLOOKUP($A16,Budget!$A:$P,12,0)),(VLOOKUP($A16,'Current Data'!$A:$P,12,0)))*1.1
Thanks!
Hi Justmeok
Try this. I just removed some parenthesis from your formula and wrapped it in an IFERROR to display 0
=IFERROR(IF(L$4>$D$1,VLOOKUP($A16,Budget!$A:$P,12,0),VLOOKUP($A16,'Current Data'!$A:$P,12,0))*1.1,0)
Your original formula also tested OK with the IFERROR
=IFERROR(IF(L$4>$D$1,(VLOOKUP($A16,Budget!$A:$P,12,0)),(VLOOKUP($A16,'Current Data'!$A:$P,12,0)))*1.1,0)
No idea why it is not working for you
You can also try this.
=IFERROR(VLOOKUP(A16,IF(L$4>$D$1,Budget!$A:$P,'Current Data'!$A:$P),12,0)*1.1,0)
Seems like this question was also posted in http://www.mrexcel.com/forum/excel-questions/956061-need-wrap-formula-ignore-n-errors.html
Hi justmeok,
Please read this on the use of IFERROR
If you post the same qs on multiple forums please say so on each forum and link to the qs. Everybody who replies to your qs has spent their own time doing so and if the answer has already been provided elsewhere, that time is wasted.
Regards
Phil
Oh my sincere apologies I did not even think of that as causing any issues! I will make sure that I do not make the same mistake again. Sorry for any inconvenience caused
