Pull data from One Sheet into another based upon criteria

Angela L

I have one sheet that has address information for employees. I am creating another sheet where I would like to pull in the address of the employee based upon the name that is entered within a specific cell.

For example: in Sheet 2 you see Name Test and below I would like to pull from Sheet 1 that specific address for the name that is listed.

Contractor Sheet (Sheet 1)

Finance (Sheet 2)

Paul Newcome

You would use something along the lines of

=INDEX({Reference Sheet Address Column}, MATCH([Primary Column]5, {Reference Sheet Name Column}, 0))

KPH

Hi @Angela L

A combination of INDEX and MATCH (if you just want to match on Name) or INDEX and COLLECT (if you want more than one thing to be considered when you match) will do this for you.

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

https://help.smartsheet.com/function/collect

Are you familiar with cross sheet references?

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Angela L

Thank you for the information, but I am still struggling how to create the formula. The address is listed on a different sheet where I created the reference, but unsure the text for the formula.

Paul Newcome

You would use something along the lines of

=INDEX({Reference Sheet Address Column}, MATCH([Primary Column]5, {Reference Sheet Name Column}, 0))