If cell equals this, then insert cell
Hello,
I am looking to auto populate a cell with some information pulled from another sheet.
So if Site Name equals 'Bury', Contract ID should populate with '0004' from other sheet.
I'm struggling to find the correct formula in order to do this, if somebody would be kind enough to help please.
Best Answer

Hey @lmaccabee
Since you are only looking at one criteria, an Index/Match should work for you.
Because this is a cross sheet reference (different source sheet) you will need to physically insert the references through the formula INSERT REFERENCE link. You cannot simply copy paste.
=INDEX({your source sheet Contract ID column}, MATCH([Site Name]@row, {your source sheet Site Name column},0))
Does this work for you
Kelly
Answers

Hey @lmaccabee
Since you are only looking at one criteria, an Index/Match should work for you.
Because this is a cross sheet reference (different source sheet) you will need to physically insert the references through the formula INSERT REFERENCE link. You cannot simply copy paste.
=INDEX({your source sheet Contract ID column}, MATCH([Site Name]@row, {your source sheet Site Name column},0))
Does this work for you
Kelly

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!