Using If and Index Match across multiple sheets

Catherine Shea

I had to break down two cross sheets due to the size of data. I created another sheet with a form. I would like to have an index match formula that if a name was found at the row, it would cross-reference the sheet tied to where that data is store and return a value. This would eliminate the need to pivot into that data sheet and manually enter the information. Note that I cannot link the cells, as original sheets are updated with data shuttle.

ss11.2.png

Andrée Starå

Hi @Catherine Shea

I hope you're well and safe!

Try something like this.

=IF(Director@row = "John Doe", the rest of your formula

And, then , If(Director@row = "Jane Doe", the rest of your formula

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