Formula to check one field to pull before running formula

[squeakums]

I have a normal vlookup formula created:

=IFERROR(VLOOKUP(L2,Guide!A:B,2,FALSE),"")

How could I add into this formula if cell DF2 has no data then use this formula, otherwise just pull whats in cell DF2? There will be a formula in cell DF2 it either brings in data or is blank.

 

[Joe4]

Try this:

=IF(DF2<>"",DF2,IFERROR(VLOOKUP(L2,Guide!A:B,2,FALSE),""))

 

[squeakums]

Joe, this formula you sent works perfectly! Thank you

 

[Joe4]

You are welcome.
Glad I was able to help!