IF Statement to return Vlookups vased off cell

[kmarks247]

Hi All,

I have a spreadsheet that I would like to automate a bit. I have multipe rows that return values. Is there a IF statement that works similar to what I'm trying to do below?

=IF(J1="1",=vlookup(A6,S:T,2,false,IF(J1="2",=vlookup(A6,S:V,4,false))

I want to know if there is something that will do basically what i tried to get the above to do where I change cell J1 and the vlookup then changes accordingly. Thanks in advance!

[Pepe Le Mokko]

Perhaps like this

Please Login or Register  to view this content.

[Ace_XL]

How about..

Please Login or Register  to view this content.