Sort and calulate help or maybe even a if statement

[Mrbanner]

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

 

[bobocat]

Hi,
You can use vlookup function to calculate $due
at the cell of $due, suppose the address for "table" in sheet 1 is B2
at B3
=vlookup(b2, sheet2!$a$1:$a$30,2,false)

 

[Pete_UK]

In cell C2 of Sheet 1 you should enter this formula:

=VLOOKUP(B2,'Sheet 2'!A$2:B$30,2,0)

You may need to adjust the ranges to suit your table. You can copy this
down column C for as many entries as you have in column B.

Hope this helps.

Pete

 

[bobocat]

Thank you. Sorry for my mistakes

"Pete_UK" <[email protected]>
???????:[email protected]...
In cell C2 of Sheet 1 you should enter this formula:

=VLOOKUP(B2,'Sheet 2'!A$2:B$30,2,0)

You may need to adjust the ranges to suit your table. You can copy this
down column C for as many entries as you have in column B.

Hope this helps.

Pete