OFFER STOCK search

[makinmomb]

This is my data on sheet1

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

<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

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

<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>

 

[JoeMo]

in E2 and copy down:
=IF(ISNA(MATCH(C2,Sheet2!1:1,0)),"","OFFER")

 

[makinmomb]

in E2 and copy down:
=IF(ISNA(MATCH(C2,Sheet2!1:1,0)),"","OFFER")

Almost there that is exactly as per above If I copy paste the formula
=IF(ISNA(MATCH(C2,Sheet2!A:A,0)),"","OFFER")

When I drag it is not commenting OFFER on E5 where by it should

 

[makinmomb]

I am sorted , I realised the C2 should then be B2

=IF(ISNA(MATCH(B2,Sheet2!A:A,0)),"","OFFER")

Thanks