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