Lookup from another sheet

Cybsss

Is there possible for smartsheet to automatically lookup the list of materials description in materials index sheet in my releasing monitoring,

Currently im using dropdown for releasing monitoring and manually copying the list of materials description from materials index, which is way too hassle cause everytime ill add items in materials index, i am always required to update also the dropdown list in releasing monitoring. I need help on this one.

Georgie

Hi @Cybsss,

If you have a unique identifier for each item that’s present in both sheets, you can use an INDEX(MATCH) formula to pull in the material name from one sheet to the other. 

For example, I can see that your “02” sheet contains a column named “ITEM CODE” - if your “03” index sheet contains this column, with a unique identifier for each item, you can then add the formula below to the MATERIAL DESCRIPTION column in the “02” sheet:

• =INDEX({Material Description}, MATCH([Item Code]@row, {Item Code}, 0))

You’ll need to set up the references (the sections in curly brackets) as you type the formula by clicking “Reference another sheet” within the formula popup (take a look here: Create cross-sheet references).

The {Material Description} reference will be the entire MATERIAL DESCRIPTION column in the 03 sheet, and the {Item Code} reference will be the entire ITEM CODE column in the 03 sheet.

For more information on INDEX MATCH formulas, check out the resources below:

• Formula combinations for cross sheet references
• INDEX Function
• MATCH Function

Does that work for you?

Georgie