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