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