If you are going to go with the one time pain of listing all the possible combo's in your lookup the formula becomes much eaiser
=INDEX(Sheet2!A:A,MATCH(Sheet1!H2,Sheet2!E:E,0))
If you get any #n/a's on the index and match formula you know that there is a new combination. Yoiu can then just add it at the bottom of the lookup table and it will show on the data sheet
I use index and match as it is more felxible than vlookup (index/match can look left for a start).
|