Using SUMIF to update prices on a worksheet

G

Greg

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top