The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!
Index/Match Formula Question or VLookup
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.
Answers
-
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))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
