Formula ignored if missing value

[Cmorgan]

Morning,

I'd appreciate any help you can give. I am using the following formula:

=IFERROR(VLOOKUP(Achieved!AE4,Lookups!$O$1:$P$9,2),0) - IFERROR(VLOOKUP('FFT Target'!AE4,Lookups!$O$1:$P$9,2),0)

The problem I'm having is that I want the result for this formula to leave the cell empty if either of the Looked Up cells are empty. Any ideas please?


Many thanks

[Richard Buttrey]

Hello,

Try

=IF(OR(Achieved!AE4="",'FFT Target'!AE4=""),"",IFERROR(VLOOKUP(Achieved!AE4,Lookups!$O$1:$P$9,2),0) - IFERROR(VLOOKUP('FFT Target'!AE4,Lookups!$O$1:$P$9,2),0))

[Richard Buttrey]

Hello,

One other thought strikes me. If you're trying to avoid an error caused by one or both of the two cell values, by presumably being blank and not appearing in the VLookup list, then perhaps

=IFERROR(VLOOKUP(Achieved!AE4,Lookups!$O$1:$P$9,2) - VLOOKUP('FFT Target'!AE4,Lookups!$O$1:$P$9,2),0)

Regards

[Cmorgan]

Perfect, many thanks.