If

[Vegs]

I'm working off two worksheets.

Worksheet 1 data looks like this:

Dept. P/N Discription Lead LeadFree Both
500 X1 TT
500 A1 PCB BLANK x x x
500 B1 FILTER x x
500 XXX3 plate
500 C1 cup x
500 XX2 Tin

Worksheet 2 is this:

P/N Description Lead Lead Free Both
A1 PCB BLANK
B1 FILTER
C1 cup

I need to copy the data in columns D, E and F from worksheet 1 to column C,
D and E on worksheet 2 for each matching p/n.

[Marcelo]

Hi Vegs,

assuming that your data on the ws1 in on the range A1:F7

on the sheet 2 use the formula on the columns C,D and E

column C =vlookup(B2,WS1!$C$2:$F$7,2,0)
column D =vlookup(B2,WS1!$C$2:$F$7,3,0)
column E =vlookup(B2,WS1!$C$2:$F$7,4,0)

hope this helps
regards from Brazil
Marcelo



"Vegs" escreveu:

> I'm working off two worksheets.
>
> Worksheet 1 data looks like this:
>
> Dept. P/N Discription Lead LeadFree Both
> 500 X1 TT
> 500 A1 PCB BLANK x x x
> 500 B1 FILTER x x
> 500 XXX3 plate
> 500 C1 cup x
> 500 XX2 Tin
>
> Worksheet 2 is this:
>
> P/N Description Lead Lead Free Both
> A1 PCB BLANK
> B1 FILTER
> C1 cup
>
> I need to copy the data in columns D, E and F from worksheet 1 to column C,
> D and E on worksheet 2 for each matching p/n.

[Nikki]

assuming you are going to lookup for P/N column

=VLOOKUP($B1,$B:$D,4,FALSE) for Lead
=VLOOKUP($B1,$B:$D,5,FALSE) Lead Free
=VLOOKUP($B1,$B:$D,6,FALSE) for both
but if you have more than one critaria or you need to sum them let me know.

"Vegs" wrote:

> I'm working off two worksheets.
>
> Worksheet 1 data looks like this:
>
> Dept. P/N Discription Lead LeadFree Both
> 500 X1 TT
> 500 A1 PCB BLANK x x x
> 500 B1 FILTER x x
> 500 XXX3 plate
> 500 C1 cup x
> 500 XX2 Tin
>
> Worksheet 2 is this:
>
> P/N Description Lead Lead Free Both
> A1 PCB BLANK
> B1 FILTER
> C1 cup
>
> I need to copy the data in columns D, E and F from worksheet 1 to column C,
> D and E on worksheet 2 for each matching p/n.