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:
Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!