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

Occasional Visitor

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

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

@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.