I have two worksheets and I would like to find the value from second
file and bring it to first file with Vlookup and if statement in
col_section. Here is the data. Thanks for the help.
Worksheet
A B C D

E F
ITEMNO CUBICMETER EXTWEIGHT HEIGHT LENGTH WIDTH
039ABZZ
039AZZZ
046ZZZZ
058AZZZ
059AZZZ
060050N
060060N
060070N
060080N
060090N


Worsheet 2 has the data this way;
A B C
ITEMNO OPTFIELD VALUE
039ABZZ CUBICMETER 1.11
039ABZZ EXTWEIGHT 20
039ABZZ HEIGHT 15
039ABZZ LENGTH 16
039ABZZ WIDTH 12
039AZZZ CUBICMETER 1.11
039AZZZ EXTWEIGHT 15
039AZZZ HEIGHT 12
039AZZZ LENGTH 6
039AZZZ WIDTH 6
046ZZZZ CUBICMETER


Reply

Assume the 039ZBZZ in sheet1 is in cell E2, then
in F2
=sumproduct(--(Sheet2!$A$2:$A$50=E2),--(Sheet2!$B$2:$B$50=F$1),Sheet2!$C$2:$
C$50)

Adjust the ranges to reflect the extent of your data

then drag fill across and down.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I have two worksheets and I would like to find the value from second
file and bring it to first file with Vlookup and if statement in
col_section. Here is the data. Thanks for the help.
Worksheet
A B C D

E F
ITEMNO CUBICMETER EXTWEIGHT HEIGHT LENGTH WIDTH
039ABZZ
039AZZZ
046ZZZZ
058AZZZ
059AZZZ
060050N
060060N
060070N
060080N
060090N


Worsheet 2 has the data this way;
A B C
ITEMNO OPTFIELD VALUE
039ABZZ CUBICMETER 1.11
039ABZZ EXTWEIGHT 20
039ABZZ HEIGHT 15
039ABZZ LENGTH 16
039ABZZ WIDTH 12
039AZZZ CUBICMETER 1.11
039AZZZ EXTWEIGHT 15
039AZZZ HEIGHT 12
039AZZZ LENGTH 6
039AZZZ WIDTH 6
046ZZZZ CUBICMETER


Reply