Using SUMIF to update prices on a worksheet

[Guest]

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.

 

[Bob Phillips]

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)