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.