vlookup question (sheet to sheet)

Jillian M

I think I need a VLookup formula but I'm stumped. I have 2 sheets where each row of data has an individual row number in a column--the data in each row is exactly the same. I need a formula on the secondary sheet to check the row number on the master sheet. If the row number on the secondary sheet matches the row number on the master sheet, then it places a "yes" in the cell on the secondary sheet. (We are trying to be able to filter out rows that are deleted on the master sheet). I hope this makes sense...

Andrée Starå

Hi @Jillian M

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

I'd recommend using an INDEX/MATCH combination instead.

Here's the structure of the formula.

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

More info.

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

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!

Jillian M

It's not working. I'm not sure where to go. I'm getting an INVALIDREF error.

=INDEX({Master Data Range 2}, MATCH({Master Data Range 3}, {row ID@row}, 0))

Paul Newcome

@Jillian M Try this adjustment:

=INDEX({Master Data Range 2}, MATCH([Row ID]@row, {Master Data Range 3}, 0))