|re: "mark which list it is in"|
I'm not sure what you mean by "mark" which list it's in. Do you mean that you want to return the name of the Named Range it is found in?
If so, perhaps this would work, assuming you have three named ranges - List1, List2, List3 - and the value you are looking for is in A1.
IF(NOT(ISNA(VLOOKUP(A1,List3,1,0))),"List3","Value Not Found")))
VLOOKUP return #N/A if a value is not found in its lookup_array. If the value is found in the list, the NOT(ISNA) will be TRUE and the text associated with that IF statement will be returned.
Posting Tip: Before posting Data or VBA Code, read this How-To.