Need help vlookup?

[Katerinia]

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

 

[Jeff]

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]

it could have been the formula I tried. Does anyone have a formula?

 

[new1]

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.






- 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;2;FALSE)

Hope it helps

new1@[no/spam]realce.net