How to pull information from one sheet to another

Paul Mangan

I have seen a lot of questions about this and I can't seem to figure it out. Super frustrating as it seems it should be very simple. I have tried multiple variations of VLOOKUP and it doesn't seem to work. I am wanting to return the value of a row into another row. Whatever is in there should be returned. This is the example of what I typed. I want it to look in the row that is labeled Team Member, on the sheet L&D Content Creation Submission. If something is there I want it to return the value in that row, if not then false. What am I doing wrong?!

Razetto

In the past I've ran into issues using Vlookup which is why I now prefer the index/match combo. Try something like this: =index({L&D Content Creation Submission},match(Team Member@row,{Team Member},0))

More on the index function here: https://help.smartsheet.com/function/index

Paul Mangan

Did not work, says #UNPARSEABLE.....

Andrée Starå

Hi @Paul Mangan

I hope you're well and safe!

Here's the structure for an INDEX/MATCH combo.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Mangan

I'm sorry I guess I don't understand. I am 2 days into SmartSheet and it's really frustrating coming from excel. I understand formulas in excel but not in SmartSheet.

Paul Newcome

Column names that have spaces, numbers and/or special characters should be wrapped in [square brackets]. Also be sure to make sure column names used in formulas match exactly the column names used in the sheet. The easiest way to do this is to click on the cell within that column to automatically generate the appropriate reference.

=INDEX({L&D Content Creation Submission}, MATCH([Team Member]@row, {Team Member}, 0))

Andrée Starå

@Paul Mangan

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.