Exactly my problem - I need something - match, lookup, index, that will look at the value in one sheet, see multiples of that value in the second sheet and return the associated value in the lookup/return column, repeatedly...