How to incorporate lists and Nested If Statements into one cell?

[Claire]

How do I create a cell using an IF statement, where it results in one of 2
lists depending if it is true or false? Is this even possible to do?

 

[JulieD]

Hi Claire

not entirely sure what you mean but how about
=IF(A1="cat",VLOOKUP(A1,Sheet2!A1:A5,2,0),VLOOKUP(A1,Sheet3!A1:A5,2,0))

if this isn't what you're after please post back with a few more details -
ie what cell is your IF going to be in, what is the test & where are the two
lists & what do you want returned.

Cheers
JulieD