Nested IF function within an IF/lookup Function

[brentcook]

I need to look for a text value in a list. If it is true then equal a value. If false, look in a different list. If true, return a different value. If false, then return a third value. Is this possible?

Example:

Apple	Asparagus		T-Bone	Meat
Orange	Brussel Sprouts
Grape	Spinach
Banana	Broccoli

<tbody>
</tbody>

Explanation:

Unsuccessful Search of Column 1 for Cell D1 leads to unsuccsesful search of column 2 = MEAT.

If found in column 1, then Fruit

If found in column 2, then Vegetable

Any ideas?

Thanks in advance

 

[yky]

Try this:

=IF(ISNA(VLOOKUP(D1,A1:A4,1,FALSE)),IF(ISNA(VLOOKUP(D1,B1:B4,1,FALSE)),"not found","Vegetable"),"Fruit")

 

[brentcook]

It worked perfectly. Thank you. I spent so long on this and I would never have thought of ISNA( .

One last thing, if the Lookup value had blanks mixed in, would I be able to leave the return value blanks as well?

 

[brentcook]

I should have tried to use my brain instead of going back to your fountain of knowledge. Ignore my last post. I can't thank you enough YKY. I was grasping at straws with this one. It works perfectly. You are a life saver.

Thanks,

Brent