VLOOKUP question
 

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.

try
=IF(A4="","",IF(VLOOKUP(A4,CSM!CSM,9,FALSE)="X","X ",IF(VLOOKUP(A4,NPM!NPM,9,FALSE)="X","X",IF(VLOOKU P(A4,PM!PM,9,FALSE)="X","X","N"))))
"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.

That did not work :( anyone else?

"bj" wrote:

try
=IF(A4="","",IF(VLOOKUP(A4,CSM!CSM,9,FALSE)="X","X ",IF(VLOOKUP(A4,NPM!NPM,9,FALSE)="X","X",IF(VLOOKU P(A4,PM!PM,9,FALSE)="X","X","N"))))
"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.

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.

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!!!!!!!

"PegL" wrote:

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.

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@

"KenRamoska" wrote:

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!!!!!!!

"PegL" wrote:

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.

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

"KenRamoska" wrote:

That did not work :( anyone else?

"bj" wrote:

try
=IF(A4="","",IF(VLOOKUP(A4,CSM!CSM,9,FALSE)="X","X ",IF(VLOOKUP(A4,NPM!NPM,9,FALSE)="X","X",IF(VLOOKU P(A4,PM!PM,9,FALSE)="X","X","N"))))
"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.