find first cell value on separate page and insert value once

[rs1aj]

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?

[teylyn]

Hello,

I'm not sure I follow completely. The master sheet may have duplicate invoice numbers. Does the LN Fee also have duplicates? Vlookup or Index/Match will return only one value: the first one that the formula finds.

Can you explain your data in a bit more detail or maybe post a sample file?

cheers, teylyn

[rs1aj]

The LN Fee worksheet will never have duplicate invoice number lines. The LN Fee worksheet lists the invoice number in column A and a dollar amount(fee) in column B.

On the master worksheet, one invoice number may be listed 10 times. I want to pull that dollar amount in column B from the LN Fee worksheet and put it on one single line of the matching invoice number on the master worksheet, not ten times.

[FDibbins]

From what I can make out, if you do a count of Inv No, something like =IF(countif($A$2:A2,A2)>1,"",your-index/Match-formula) this should only pull in the matching value, the 1st time it finds the Inv No. After that, duplicate Inv No's will be ignored (in Master)