Forum

Notifications
Clear all

Returning a Value if Error of #VALUE!

3 Posts
2 Users
0 Reactions
133 Views
(@benjamip)
Posts: 89
Estimable Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
(@benjamip)
Posts: 89
Estimable Member
Topic starter
 

Thanks Sunny

Works perfectly

 

Regards

Paul

 
Posted : 23/01/2021 1:04 pm
Share: