VLOOKUP question

[Guest]

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.

 

[Guest]

tr
=IF(A4="","",IF(VLOOKUP(A4,CSM!CSM,9,FALSE)="X","X",IF(VLOOKUP(A4,NPM!NPM,9,FALSE)="X","X",IF(VLOOKUP(A4,PM!PM,9,FALSE)="X","X","N"))))

 

[Guest]

That did not work anyone else?

try
=IF(A4="","",IF(VLOOKUP(A4,CSM!CSM,9,FALSE)="X","X",IF(VLOOKUP(A4,NPM!NPM,9,FALSE)="X","X",IF(VLOOKUP(A4,PM!PM,9,FALSE)="X","X","N"))))

 

[Guest]

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(ISNA(VLOOKUP(A4,NPM,9,FALSE)),IF(ISNA(VLOOKUP(A4,PM,9,FALSE)),"N","Z"),"Y"),"X"))

 

[Guest]

Woo hoo. Yes....now I just gotta figure out how to come up with something
better than X Y or Z....these were used like a check off list. Thanks so
much!!!!!!!

 

[Guest]

Peg...
I put this in 4 cells Each time using a different column number.
Now it puts the X Y or Z in all four columns even if one is chosen. HELP@

 

[Guest]

What happens if you break the sections apart
=VLOOKUP(A4,CSM!CSM,9,FALSE) (With or without the CSM!)
etc.
for the ones without a match and ones with a match