I have spent about 7 hours trying to insert the Left function into multiple criteria Index Match formula's that I have found on the internet but have been unsuccessful. Here is what I am attempting to do:
Controls Pricing 201.jpg
Here is the best I could do at putting a formula together:Anybody out there have a solution? I have also attached my example worksheet.
Please Login or Register to view this content.
Thanks for your help!
Marvelous (not so much)