Index Set Up

I have two Sheets: P2P and LookupP2PWorkflow (two fields Plant and Workflow).

P2P contains columns called Location and a column called Workflow.

LookupP2PWorkflow contains only 2 columns Plant and Workflow.

P2P.Location = LookupP2PWorkflow.Plant

I would like to write a formula that references the Location column in P2P and goes to the LookupP2PWorkflow sheet to find its corresponding Workflow value. I"m trying to set up an Index. This is the formula I have that isn't working:

=INDEX(LookupP2PWorkflow:LookupP2PWorkflow,Location@row,2)

Any help is greatly appreciated!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!