It was hard to come up with a proper title to this thread so I'm sorry if its confusing.

I have one worksheet(Master) with various Invoice numbers listed multiple times down column A. I have a second worksheet(LN Fee) that has the same various Invoice numbers listed once down column A.

I want to pull in the value of column B in worksheet(LN Fee) to column AJ of the (Master) where the invoice number matches. A simple index/match or vlookup would normally work but since each invoice number is listed multiple times on the (Master) sheet, the formula would pull in the value of column B from worksheet(LN Fee) many times and I only need to pull it in once.

Any suggestions?