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.


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.