#N/A

[midfieldgeneral11]

Good Morning

I have a formulae which hwen looking in the cell comes back with a #N/A

The formulae is =vlookup(A7,data,2,false)

But because the field A7 is blank it come back with #N/A

I would like the formulae to be blank as the column A will be blank until populated.

Thanks
Simon

 

[VoG]

Try

=IF(ISNA(VLOOKUP(A7,data,2,FALSE)),"",VLOOKUP(A7,data,2,FALSE))

 

[midfieldgeneral11]

Thanks for that....
Can you help one more....

=+C7-D7 comes up with #VALUE can I change the formulae to be blank also?

Thanks for your help

Simon

 

[VoG]

Try

=IF(ISERROR(C7-D7),"",C7-D7)