=IFERROR(LOOKUP(1000,(SEARCH('Test range'!$A$6:$A$22,D4)),'Test range'!$B$6:$B$22),"")
I am using this equation and it works fabulously, except that I would like to be able to use a real range instead of $A$6:$A$22 and $B$6:$B$22. The reason is that I am realising that I have other combinations to add, but don't know how many.
One way around it is to simply increase the range and input blanks for the lookup and output, but is there a more elegant method?
Bookmarks