If and Vlookup together

[saschmeling]

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 accept that either, gives an error.

Any suggestions would be appreciated.

Thanks,

 

[Domenic]

Try...

=IF(A4 ="T",VLOOKUP(I4,treatlookup,11,FALSE),VLOOKUP(I4,itemlookup,22,FALSE))

Hope this helps!

 

[saschmeling]

Thanks,
Thought I tried that but guess I missed it in my frustration. Seems to be working well though.

 

[Domenic]

You're welcome!