VLookUp single value in multiple sheets

=IF(ISNA(VLOOKUP(D2,Added!A:A,1,FALSE)),
IF(ISNA(VLOOKUP(D2,'Not Added'!A:A,1,FALSE)),
IF(ISNA(VLOOKUP(D2,Exisitng!A:A,1,FALSE)),
"Not Found","Existing"),
"Not Added"),
"Added")

Where

-- "Added", "Not Added" and "Existing" are sheet names.
-- Above formula is searching for value in D2 in all the three sheets and returning the specified values.