Index Match with multiple ranges?
I am stumped on a formula and hoping for some direction. I am attempting to put together an Index(match) that will bring in the "order number" from sheet two to the "Assigned to Contract" column, if the unique identifier appears in any of the "Unique ID columns" (Columns in between hidden for better viewing).
Is there a way to do an Index Match with multiple ranges?
Thanks in Advance!
Help Article Resources
Check out the Formula Handbook template!