How can I link a row from one sheet to another using the condition of a specific word?

Schnag

Hey guys,

I'm having trouble putting together an automatized cell linking formula.

The goal is to link an entire row from one sheet to another based on the condition that within a certain column there is a specific word. Each row with this word should be linked to the new sheet if possible.

Andrée Starå

Hi @Schnag

I hope you're well and safe!

I'd recommend using an INDEX/MATCH combination, with an added check for the specific word.

Something like this, but with the addition of the check for the word.

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

Depending on your country/region, you'll need to exchange the comma for a period and the semi-colon for a comma.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!