Register
Log In
Unanswered
Home
Power Query
Power Pivot
Power BI
June 25, 2016
Offline
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!
See Answer
Dashboards
June 25, 2016
Offline
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
Dashboards
June 25, 2016
Offline
Seems like this question was also posted in http://www.mrexcel.com/forum/e.....rrors.html
October 5, 2010
Offline
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
Power Query
Power Pivot
Power BI
June 25, 2016
Offline
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Â
Most Users Ever Online: 57
Currently Online: Mark Lund, Rudi, Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
