IF statement when formula result is blank
 

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!

That should work as is.

Try

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

--

HTH

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


"Bonnie" wrote in message
...
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!

Bonnie Wrote:
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!

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


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=401158