formula help-I need a formula to look up a ssn

[ejhowardokcpsorg]

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]

@ejhowardokcpsorg You may use VLOOKUP or XLOOKUP, depending on the Excel version you work with.  Google and find many resources on these functions.

[#3]

@ejhowardokcpsorg 

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.