IF statement when formula result is blank

[Guest]

I am trying to use the conditional formula:
=IF(F7="",D7,F7) where F7 is a vlookup formula that returns a general value

If the result of the vlookup is a blank cell, how do I reference that
vlookup result in order for the IF statement to return D7?

Thanks!

 

[Bob Phillips]

That should work as is.

Try

=IF(TRIM(F7)="",D7,F7)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[ilanr01]

I am trying to use the conditional formula:
=IF(F7="",D7,F7) where F7 is a vlookup formula that returns a genera
value

If the result of the vlookup is a blank cell, how do I reference that
vlookup result in order for the IF statement to return D7?

Thanks!

Try =IF(isblank(F7)="",D7,F7)
Ila