Hello everyone.
Apologies I can't attach an example as I'm at work and can't access the Internet on the computer. So I'll try my best to explain.
I'm trying to work out a formula that starts with an if.
If(F5:F39<>"",Vlookup(this is what I'm struggling with, operator,2,False),"")
The struggling with part is that for example
If F7 contains text, the lookup_value is in A7, if F18 contains text then the lookup_value is in F18 but I don't know how to do that.

Thank-you for reading and thinking this through with me.