Using: Excel 2000, on Windows 98

Good morning! I'm hoping that someone on here can possibly help me. I
have basic Excel knowledge, but this is out of my skill set.

My boss has given me a project to work on, in which I have a workbook
with two worksheets that I am dealing with. The worksheets are labelled
PRICE and SUMMARY.

On the PRICE sheet, I have several columns. Column A lists the product
name, Columns E list the per page charge for the *red* program, and
Column G lists the per page charge for the *blue* program. Those are
the columns we will be dealing with. All specific information on this
page starts on Row 5, with the headings, etc on Rows 1 - 4.

On the SUMMARY sheet, we have Column A which lists the product name,
Column E which lists the cost per page for *red* and Column G which
lists the cost per page for *blue*. As with the PRICE sheet, all
specific information on this page starts on Row 5, with the headings,
etc on Rows 1 - 4.

What I need to be able to do, is when one of our sales guys enters a
product name in Column A on the SUMMARY worksheet (I have this set up
with Data Validation, so the name will be the same format on both the
PRICE and SUMMARY worksheets), have columns E & G automatically fill in
with the corresponding information (columns E & G) from the PRICE
worksheet, without the sales guy having to go and look up the
information on the other sheet.

I'm not very experienced with setting up formulas (but I'm trying to
learn!), so any help and guidance you could offer would be greatly
appreciated.

Samantha


--
SamanthaM
------------------------------------------------------------------------
SamanthaM's Profile: http://www.excelforum.com/member.php...o&userid=27839
View this thread: http://www.excelforum.com/showthread...hreadid=473461