Using SUMIF to update prices on a worksheet
 

In Excel 2003, I have a 2 page workbook. First page is all items and prices.
Second page is like a "catalog order form" with same items, same prices and
a field for quantity ordered.
neet to be able to paste in new prices on the first page, to
automatically update prices on second page.
since I add items often, the sequence will be different (slightly) whenever I update the prices.

.... I did this once before using SUMIF function and naming columns on both
pages, but can't find my notes and can't seem to recreate it.

Using SUMIF to update prices on a worksheet
 

To get the prices just use VLOOKUP

=VLOOKUP(item_no, Sheet1!table_ofitems_and_prices,2,False)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Greg" wrote in message
...
In Excel 2003, I have a 2 page workbook. First page is all items and
prices.
Second page is like a "catalog order form" with same items, same prices
and
a field for quantity ordered.
neet to be able to paste in new prices on the first page, to
automatically update prices on second page.
since I add items often, the sequence will be different (slightly)
whenever I update the prices.

... I did this once before using SUMIF function and naming columns on both
pages, but can't find my notes and can't seem to recreate it.