I used X for CSM, Y for NPM and Z for PM in the following formula...
IF(A4="","",IF(ISNA(VLOOKUP(A4,CSM,9,FALSE)),IF(IS NA(VLOOKUP(A4,NPM,9,FALSE)),IF(ISNA(VLOOKUP(A4,PM, 9,FALSE)),"N","Z"),"Y"),"X"))

"KenRamoska" wrote:

Hi,
I have 4 sheets in my work book. Full CSM NPM PM
On the CSM Sheet I have the range CSM...and so on.
On the full sheet I have this formula.
Here is my formula...
=IF(A4="","",IF(VLOOKUP(A4,CSM,9,FALSE)="X","X",IF (VLOOKUP(A4,NPM,9,FALSE)="X","X",IF(VLOOKUP(A4,PM, 9,FALSE)="X","X","N"))))

My goal was when someone types a name it would look on these 3 sheets and
when it found the match put it on sheet 4. The problem is it knows to look at
the CSM Sheet and the table called CSM. If I put a name on another sheet like
the NPM Sheet then it does not see the range NPM on the NPM Sheet.
I don't want all of this on one sheet. Is there any other way?
Thanks.