Power Query
Power Pivot
Power BI
June 25, 2016
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!
VIP
Trusted Members
June 25, 2016
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)
Answers Post
VIP
Trusted Members
June 25, 2016
Seems like this question was also posted in http://www.mrexcel.com/forum/e.....rrors.html
October 5, 2010
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
1 Guest(s)