Alternative (might be better)
=IF(COUNTIF(Returnable!A:A,Sheet1!A1),"Returnable" ,IF(COUNTIF('Non
Returnable'!A:A,Sheet1!A1),"Non Returnable", "Who Knows?"))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Byron720" wrote in message
...
I have a file with two sheets: Returnable and Not Returnable. I need a
formula on a third sheet that tells me if a part is returnable or not
based
on the lists.