Forum Discussion
formula help-I need a formula to look up a ssn
I have two spreadsheets
1st with names and Member IDs'
2nd with names and SSN
I need a formula for an added column in the 1st worksheet that will look up the ssn on the other worksheet and produce it in the 1st
2 Replies
You can use VLOOKUP. In a cell in row 2:
=IFERROR(VLOOKUP(A2, 'Second Sheet'!A:B, 2, FALSE), "")
Replace Second Sheet with the actual name of that sheet, then fill down.
ejhowardokcpsorg You may use VLOOKUP or XLOOKUP, depending on the Excel version you work with. Google and find many resources on these functions.
