IF help

[dd]

i have to calulate a Excel Spread sheet on a weekly basis
so i know how to pay staff for product sales
the file is output from a weird old dos program into a excel document

I have 2 sheet inside a Excel document
lets call them Sheet 1 and sheet 2

Sheet 1
has 3 columums
Date Product and $Due
etc
8/06/06 TABLE
8/06/06 CHAIR
8/06/06 TABLE


$due Columum is not filled and i need this to auto fill


Sheet 2
has a list of products in Columum 1 and 2 has the price on it
PRODUCT $DUE
Table $50

I need to do a if statement
that if sheet 1 PRODUCT = SHEET 2 PRODUCT THEN sheet 1 $DUE = sheet 2 $due

i have around about 30 products and with this be easier for me if i can get
it to auto put the $due next to it. so i need it to really check if SHEET 1
PRODUCT 1 = ANY OF THE 30 products sheet 2 then to input the price in $due
on sheet 1

 

[Roger Govier]

Hi
On sheet 1 in cell C2 enter
=IF(ISERROR(VLOOKUP(B2,Sheet2!$A:$B,2,0)),0,VLOOKUP(B2,Sheet2!$A:$B,2,0))
copy the formula down column C as far as required.