This is my data on sheet1
<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2">
<col width="337" style="width: 253pt; mso-width-source: userset; mso-width-alt: 12324;">
<col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<tbody>
</tbody>
GEMMA ARIZONA is an offer stock where offer stock codes are on sheet2 row 1, what is the formula on cell E2 to tell go find match on offer database and comment OFFER if it finds match and leave comments if not offer stock thus the result should look as follows once I drag the formula
<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2">
<col width="337" style="width: 253pt; mso-width-source: userset; mso-width-alt: 12324;">
<col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
DATE | CODE | DESCRIPTION | AMOUNT |
02/12/2013 | 103.002.04 | SYN-147-C/P - SYNERGIE 4-WAY CONC BATH | 24,321 |
02/12/2013 | 103.002.06 | SYN-109S-C/P - SYNERGIE 2-HOLE BASIN | 37,478 |
02/12/2013 | 174.000.01 | TILE MORTAR IN WHITE NO.NIC-C1 | 3,448 |
02/12/2013 | 100.000.33 | GEMMA 30 X 30 = ARIZONA BEIGE | 28,965 |
02/12/2013 | 107.000.36 | TILE EDGING STRIPS 10mmx2.5m GLACIER | 672 |
GEMMA ARIZONA is an offer stock where offer stock codes are on sheet2 row 1, what is the formula on cell E2 to tell go find match on offer database and comment OFFER if it finds match and leave comments if not offer stock thus the result should look as follows once I drag the formula
DATE | CODE | DESCRIPTION | AMOUNT | |
02/12/2013 | 103.002.04 | SYN-147-C/P - SYNERGIE 4-WAY CONC BATH | 24,321 | |
02/12/2013 | 103.002.06 | SYN-109S-C/P - SYNERGIE 2-HOLE BASIN | 37,478 | |
02/12/2013 | 174.000.01 | TILE MORTAR IN WHITE NO.NIC-C1 | 3,448 | |
02/12/2013 | 100.000.33 | GEMMA 30 X 30 = ARIZONA BEIGE | 28,965 | OFFER |
02/12/2013 | 107.000.36 | TILE EDGING STRIPS 10mmx2.5m GLACIER | 672 |