Using SUMIF to update prices on a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Back
Top