I am trying to use a formula that states the following:
If A4 = T Then Vlookup
Else Vlookup2
Here is what I have written that it does not like.
=IF(A4 = "T","=VLOOKUP(I4,treatlookup,11,FALSE)","=VLOOKUP(I4,itemlookup,22,FALSE)")
I tried without the quotes around the =Vlookup but it does not...