Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to Autofill Info based on Other Data
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 |
#2
|
|||
|
|||
=VLOOKUP(D3,PRICE!$D$3:$G$8,4,FALSE)
Put this formula on the summary page where you need the price to appear. D3 is the lookup value (product name) PRICE! tells the formula to "look at" the price tab $D$3:$G$8 is the range on the price tab where the product names and prices are listed. The first column "D" has to be the product name and you will need to lock this range with the dollar signs (as shown above). 4 is the number of columns over from the product name where the price is (you have to include product name when counting the columns) FALSE will return the price for the exact product entered on the summary tab. Once you have typed this formula in (check it for accurracy) then you can just copy it down the page. Hope this helps. "SamanthaM" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Charts based on data in Table | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions |