Need to put a value in the blank column #N/A using the ss#. If the ss#
matches, then the value on Worksheet SAPCODE worksheet.


FINAL SHEET (name of workbook)
COLUMNS AW and AX (ROW1 has headers)
Row two begins data
Column AW is a list of Social Security Numbers
Column AX is a number code I need to get from another worksheet (currently
blank)
Following Columns and Previous columns contain misc data
ex.
COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 #N/A DATA
DATA
3 222222222 #N/A DATA
DATA
4 333333333 #N/A DATA
DATA
5 444444444 #N/A DATA
DATA
6 555555555 #N/A DATA
DATA

Workbook name SAPCODES
COL
Rows A B C D
1 NAME OLD CODE SS# NEW SAP CODE
2 Smith,Jane 431057 111111111 20001157
3 Smith, John 509009 222222222 20001930
4 Smith, Harry 445561 333333333

RESULT SOMETHING LIKE:

COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 20001157 DATA
DATA
3 222222222 20001930 DATA
DATA
4 333333333 DATA
DATA
5 444444444 DATA
DATA
6 555555555 DATA
DATA

Sounds like a data type mismatch. The ss# in one area may be formated as
text and the other is text. I would multiplying the AW column by 1 to ensure
that it was a number. Good luck.

"Katerinia" wrote:

Need to put a value in the blank column #N/A using the ss#. If the ss#
matches, then the value on Worksheet SAPCODE worksheet.


FINAL SHEET (name of workbook)
COLUMNS AW and AX (ROW1 has headers)
Row two begins data
Column AW is a list of Social Security Numbers
Column AX is a number code I need to get from another worksheet (currently
blank)
Following Columns and Previous columns contain misc data
ex.
COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 #N/A DATA
DATA
3 222222222 #N/A DATA
DATA
4 333333333 #N/A DATA
DATA
5 444444444 #N/A DATA
DATA
6 555555555 #N/A DATA
DATA

Workbook name SAPCODES
COL
Rows A B C D
1 NAME OLD CODE SS# NEW SAP CODE
2 Smith,Jane 431057 111111111 20001157
3 Smith, John 509009 222222222 20001930
4 Smith, Harry 445561 333333333

RESULT SOMETHING LIKE:

COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 20001157 DATA
DATA
3 222222222 20001930 DATA
DATA
4 333333333 DATA
DATA
5 444444444 DATA
DATA
6 555555555 DATA
DATA

it could have been the formula I tried. Does anyone have a formula?
--
Excel isnt just a program its a metaphor for life. Sometimes it''s easy and
boring.. sometimes it''s a little challenging and great.. then there are days
it will drive you absolutely INSANE.


"Jeff" wrote:

Sounds like a data type mismatch. The ss# in one area may be formated as
text and the other is text. I would multiplying the AW column by 1 to ensure
that it was a number. Good luck.

"Katerinia" wrote:

Need to put a value in the blank column #N/A using the ss#. If the ss#
matches, then the value on Worksheet SAPCODE worksheet.


FINAL SHEET (name of workbook)
COLUMNS AW and AX (ROW1 has headers)
Row two begins data
Column AW is a list of Social Security Numbers
Column AX is a number code I need to get from another worksheet (currently
blank)
Following Columns and Previous columns contain misc data
ex.
COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 #N/A DATA
DATA
3 222222222 #N/A DATA
DATA
4 333333333 #N/A DATA
DATA
5 444444444 #N/A DATA
DATA
6 555555555 #N/A DATA
DATA

Workbook name SAPCODES
COL
Rows A B C D
1 NAME OLD CODE SS# NEW SAP CODE
2 Smith,Jane 431057 111111111 20001157
3 Smith, John 509009 222222222 20001930
4 Smith, Harry 445561 333333333

RESULT SOMETHING LIKE:

COL AW AX AY
AZ
ROW
1 SS# NEEDED CODE INDICATOR EXTERNAL PI
2 111111111 20001157 DATA
DATA
3 222222222 20001930 DATA
DATA
4 333333333 DATA
DATA
5 444444444 DATA
DATA
6 555555555 DATA
DATA

On 8 avr, 22:11, Katerinia
wrote:
it could have been the formula I tried. *Does anyone have a formula?
--
Excel isnt just a program its a metaphor for life. *Sometimes it''s easy and
boring.. sometimes it''s a little challenging and great.. then there are days
it will drive you absolutely INSANE.



"Jeff" wrote:
Sounds like a data type mismatch. *The ss# in one area may be formated as
text and the other is text. *I would multiplying the AW column by 1 to ensure
that it was a number. *Good luck.

"Katerinia" wrote:

Need to put a value in the blank column #N/A *using the ss#. *If the ss#
matches, then the value on Worksheet SAPCODE worksheet.

FINAL SHEET (name of workbook)
COLUMNS AW and AX (ROW1 has headers)
Row two begins data
Column AW is a list of Social Security Numbers
Column AX is a number code I need to get from another worksheet (currently
blank)
Following Columns and Previous columns contain misc data
ex.
COL * *AW * * * * * * * AX * * * * * * * * * * * * * * * * * * * * *AY * * *
* * * * * * * *AZ
ROW
1 * * * * * SS# * * * * * * * * * *NEEDED CODE * * *INDICATOR * * * * *EXTERNAL PI
2 * * * * 111111111 * * * * * * * #N/A * * * * * * * * * * *DATA * * * * * * * * * *
* DATA
3 * * * * 222222222 * * * * * * * #N/A * * * * * * * * * * *DATA * * * * * * * * * *
* DATA
4 * * * * 333333333 * * * * * * #N/A * * * * * * * *DATA * * * * * * * * * * *
DATA
5 * * * * 444444444 * * * * * * #N/A * * * * * * * *DATA * * * * * * * * * * *
DATA
6 * * * * 555555555 * * * * * * * *#N/A * * * * * * * * * * DATA * * * * * * * * *
* *DATA

Workbook name SAPCODES
COL
Rows * * A * * * * * * * * * * B * * * * * * * * * C * * * * * * * * * * * *D
1 * * * *NAME *OLD CODE * * * * * * *SS# * * * * * * * * * * *NEW SAP CODE
2 * * * Smith,Jane * *431057 * * * * 111111111 * * * * * * 20001157
3 * * * Smith, John * 509009 * * * * 222222222 * * * * * * 20001930
4 * * * Smith, Harry *445561 * * * * 333333333 * * * * * * *

RESULT SOMETHING LIKE:

COL * *AW * * * * * * * AX * * * * * * * * * * * * * * * * * * * * *AY * * *
* * * * * * * *AZ
ROW
1 * * * * * SS# * * * * * * * * * * NEEDED CODE * * *INDICATOR * * * * *EXTERNAL PI
2 * * * * 111111111 * * * * * * *20001157 * * * * * * * * * * * DATA * * * *
* * * * * * *DATA
3 * * * * 222222222 * * * * * * * 20001930 * * * * * * * * * * *DATA * * * *
* * * * * * *DATA
4 * * * * 333333333 * * * * * * * * * * * * * * * * * * * * DATA * * * * * * * *
* * * DATA
5 * * * * 444444444 * * * * * * * * * * * * * * * * * * * * DATA * * * * * * * * * *
*DATA
6 * * * * 555555555 * * * * * * * * * * * * * * * * * * * * DATA * * * * * * * *
* * * DATA- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -

Hello,

I suppose that SAPCODE is a worksheet name in SAPCODES workbook.
If I understand well, the formula in AX 2 should be : =VLOOKUP(AW2;
[SAPCODES]SAPCODE!C:D;2;FALSE)

Hope it helps