Reference from Another Sheet Based on Criteria

Kimberlee Adam

There has got to be an easy solution... I can do this very easy with Reports but I'm trying to do it in a Sheet so I can integrate it into another application that wouldn't pull data from a Report.

All I want to do is reference a few columns from my main sheet based on a team members "Current Assigned Team".

Paul Newcome

You will need to insert a text/number column (called "Number" in this example) and manually prefill it with the numbers 1 through however many rows you will need.

Then you would use this:

=IFERROR(INDEX({Column To Pull Over}, Number@row), "")

Eric Law

@Kimberlee Adam Can you provide and example? What are you inputting and you are using as a reference and what information are you pulling from the other sheet? You can try an index/match

Paul Newcome

Are you able to provide more screenshots with some sample data for context?

Kimberlee Adam

This is a screenshot of a very large Sheet that has lots of data on each employee. I'm only showing a small screenshot because I'm trying to protect company data.

So what I'm trying to do, is create a cross-reference to this spreadsheet so I still only need to update the data in one place to a basic sheet with only a few columns. I've tried Vlookup, Match, If statement and not doing it correctly.

I can easily do this with Smartsheet Reports, and I want to display this information on a Miro Board but unfortunately Miro does not use Reports. So I basically have to create a Sheet to display this same information without having to mess with my original Sheet.

Thank you,

Kim

Paul Newcome

You will need to insert a text/number column (called "Number" in this example) and manually prefill it with the numbers 1 through however many rows you will need.

Then you would use this:

=IFERROR(INDEX({Column To Pull Over}, Number@row), "")

Kimberlee Adam

I'm still getting an INCORRECT ARGUMENT SET

Trying to pull the Name of the team member, if the person works on the Tech Support team from another Sheet, "US Digital Team Members".

Tried all kind of different ways to do this and I'm still confused.

Paul Newcome

Did you create the Number column as mentioned in my last comment?

Kimberlee Adam

Oh wow! I'm so sorry, I did miss that. It worked!!! You are awesome. Thank you again for your help!

Paul Newcome

Happy to help. 👍️