Pull data from other sheet.

tindalli

Hi, new to managing projects on Smartsheet. Current struggle: Sheet A and Sheet B have "Vehicle Identification Number" columns with unique values for each row.

Sheet A has an "Order ID" column, which lists the unique ID associated with the "Vehicle Identification Number" of the same row.

I need to create an "Order ID" column for Sheet B now, but I want it to auto-populate data in the Sheet A "Order ID' column, as long as the "Vehicle Identification Number" values matches in both sheets.

Not sure if this is simple or not, but everything I have tried has not worked. And I would be looking a ton of manual copy and pasting hours if nothing else works.

Thanks😅

Kelly Moore

Hey @tindalli

Try this

=IFERROR(INDEX({sheet A Order ID column},MATCH([Vehicle Identification Number]@row, {sheet A Vehicle Identification Number column},0)),"")

Remember that since these are cross sheet references, you'll have to manually insert the references from the formula wizard window. You cannot simply copy paste this formula into Sheet B.

Will this work for you?
Kelly

In case you're unfamiliar with cross sheet references:

https://help.smartsheet.com/learning-track/level-3-advanced-users/advanced-cross-sheet-formulas

Kelly Moore

Hey @tindalli

Try this

=IFERROR(INDEX({sheet A Order ID column},MATCH([Vehicle Identification Number]@row, {sheet A Vehicle Identification Number column},0)),"")

Remember that since these are cross sheet references, you'll have to manually insert the references from the formula wizard window. You cannot simply copy paste this formula into Sheet B.

Will this work for you?
Kelly

In case you're unfamiliar with cross sheet references:

https://help.smartsheet.com/learning-track/level-3-advanced-users/advanced-cross-sheet-formulas

tindalli

Thank you so much! This worked