Gents,
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)
Some of the names you are using don't seem to exist in your sheet, so using cell references you should be able to use this "array formula"
=INDEX(C16:H33,MATCH(1,(A16:A33=LEFT(A7,5))*(B7=B16:B33),0),MATCH(C7,C15:H15,0))
confirmed with CTRL+SHIFT+ENTER
....but note that in your example the first 5 characters of A7 are AB 32 and that doesn't match any entry in A16:A33
Audere est facere
daddylonglegs - Thank you so much. You are the best!
I had to use bogus data so I did have some errors in my example data - thanks for pointing that out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks