INDEX & MATCH using multiple Columns - Formula help

I just can't wrap my head around this one. I have read a lot about INDEX and Match but I have not been able to make this one work.

Heres what I need to do

  1. When the profile and finish match on another REF sheet,(The same setup with 2 columns) it will give me a value for my Formula cell. (Just need to copy over to this sheet)



Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner

joe.goetschel@scscloud.com

Save My Contact

"The only real limitation of Smartsheet is the level of effort required to achieve your goal."

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!