Extract first instance of Invoice number/freight charge from one sheet by Invoice number from another sheet

[DennisYoung]

I have 2 sheets, the first (Sheet1) with a list of unique Invoice numbers, the second sheet (Sheet2) has duplicate Invoice numbers and freight charges. I want to extract just the first freight charge from sheet 2 into a new column in sheet1 by the invoice number

Sheet1 Sheet2 Final Sheet1

A B A B A B
Invoice# Freight$ Invoice# Freight$ Invoice# Freight$
123456 123456 $100.00 123456 $100.00
123457 123456 $100.00 123457 $200.00
123458 123456 $100.00 123458 $300.00
123457 $200.00
123457 $200.00
123458 $300.00

 

[Fluff]

Could sheet 2 have different charges for the same invoice?

 

[DennisYoung]

Could sheet 2 have different charges for the same invoice?

No, they will be the same at all times

 

[Fluff]

In that case you can use

=INDEX(Sheet2!$B$2:$B$500,MATCH(A2,Sheet2!$A$2:$A$500,0))

 

[DennisYoung]

In that case you can use

=INDEX(Sheet2!$B$2:$B$500,MATCH(A2,Sheet2!$A$2:$A$500,0))

I messed up, I had it backwards a bit. Sorry!

Sheet1 has Sheet2 has
Invoice$ Freight$....................Invoice# Freight$
123456 123456 100.00
123456 123457 200.00
123456 123458 300.00
123457
123457
123458

and I need
Sheet1
Invoice# Freight$
123456 100.00
123456
123456
123457 200.00
123457
123458 300.00

 

[Fluff]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,SUMIFS(Sheet2!B:B,Sheet2!A:A,A2),"")

 

[DennisYoung]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,SUMIFS(Sheet2!B:B,Sheet2!A:A,A2),"")

Perfect! Thank You very much. This worked perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.