Index/Match Formula Question or VLookup

Rebecca Bailey

I am trying to set up a formula to populate a cell in my current sheet from information in another sheet (ILW Graduate Lookup Table). I want to populate the information in the column titled: Last 4 SSN on the ILW Graduate Lookup Table into my current sheet in the SSN Check column but I need the formula to reference the Worknet ID at the row on the ILW Graduate Lookup Table to find the correct row for the information.

Paul Newcome

It sounds to me like you need an INDEX/MATCH.

=INDEX({Column To Pull From}, MATCH([Column To Match On]@row, {Column To Match In}, 0))