Hi Rick,
Thanks for this code. Would it be possible to modify it to find a combination of strings in different columns? I have attached my example spreadsheet in case it makes it easier.
lookup_test.xlsm
Basically, I want my users to select values from three different dropdowns (B2:B4 in my example). Based on these selections I'd like the function to determine which combo of columns H-J fits and return the corresponding value from G.
Perhaps I'm barking up the wrong tree?
Thanks so much!
Matt
Bookmarks