View Single Post
  #1   Report Post  
Bonnie
 
Posts: n/a
Default 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!