Cross Sheet Logic/Data Sync

Hi,

I have a signup sheet that I am trying to get to update from another sheet.

I essentially want to take "Unique Code from cell X on Sheet A and look for it anywhere in Column "Code" on Sheet B. Once it finds it on Sheet B, I want it to return the data contents from another column in the corresponding row to Sheet A.

For example if JFCODE is in Code215 on Sheet A and then shows up in the Code Column on Sheet B in Code25, I want Result25 from Sheet B to show up in Sheet A in Result215

I have played around with a few formulas and searched within the community... but thus far I have failed epically.

Any guidance much appreciated!

Thanks,

Jeff

Find more posts tagged with

Formulas

Reports

Comments

Andrée Starå

Hi Jeff,

There are a few different ways to structure a solution.

I'd recommend using cross-sheet formulas, VLOOKUP or a combination of INDEX/MATCH.

Is it only one columns data that you want to show in the other sheet?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…