Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
133
Views
Topic starter
Hi
I want the Value if Error to be a blank cell but with the following formula it is returning a Value if Error of #VALUE!
If I change "" to 0 it returns 0
=IFERROR(VLOOKUP($F$18,Data!$A$1:$KA$63,MATCH($A33,Data!$A$1:$KA$1,0),FALSE),"")-IFERROR(VLOOKUP($F$17,Data!$A$1:$KA$63,MATCH($A33,Data!$A$1:$KA$1,0),FALSE),"")
Can anyone help?
Thanks
Paul
Posted : 22/01/2021 9:49 am
Try wrapping the entire formula with another =IFERROR(<The entire formula>,"")
The error is occurring because you are using a "" to subtract another "" or value.
Posted : 22/01/2021 12:43 pm
Topic starter
Thanks Sunny
Works perfectly
Regards
Paul
Posted : 23/01/2021 1:04 pm