Conditional cross reference data from another sheet

sehret

I have a column (vendor names) that has an underlying picklist for a form attached to the main SmartSheet. Now I want to auto-fill 2 additional columns from another SmartSheet based on the chosen vendor name. Is that possible and if so, how?

kowal

hi @sehret,

now when I read your problem one more time yeah it's typical vlookup function not dynamic dropdown list based on different sheet.

my recommendation instead of going with vlookup try to master index/match (those are much safer)

https://www.youtube.com/watch?v=_vMuSLpOZ_g

kowal

hi @sehret,

The dropdown columns are static and cannot out of the box be setup dynamically based on data from other sheet.

Bridge can solve it for you if you are willing to invest or if you google for such solution some of the partners created APPs that will do it for you as well.

sehret

@kowal I figured it out. It worked with referencing the separate sheet, vlookup and formula.

kowal

hi @sehret,

now when I read your problem one more time yeah it's typical vlookup function not dynamic dropdown list based on different sheet.

my recommendation instead of going with vlookup try to master index/match (those are much safer)

https://www.youtube.com/watch?v=_vMuSLpOZ_g