Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List & VLOOKUP
I have a question and I hope someone can help. I have two
spreadsheets. 1) Contains a history of consumables for printers (Date, Printer Name, Description, Cost), 2) Contains list of consumables and their current cost ($). This is what I currently have done. Sheet 1 contains a validation list for the Printer Name and Description fields. These are retrieved from Sheet 2 via to named ranges (Printers & Supplies). On Sheet 1 in the Cost column I have a VLOOKUP to automatically insert the current cost of the supply (ex. =IF(C4="","",VLOOKUP(C4,SupplyLookup,2,FALSE)) ). Here is my problem. When I update the current cost of the supplies on Sheet 2, the costs are reflected on all related fields on Sheet 1. This is not my desired result. I would like to be able to select the supply from a drop down list, have the cost inserted from Sheet 2, but only for new rows not previously recorded rows. Please help... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List & VLOOKUP
Why don't you add a date when the new rows are added into sheet? Then
include the date in the IF statement one sheet one. Use the date to determine the new rows. "j@ckle" wrote: I have a question and I hope someone can help. I have two spreadsheets. 1) Contains a history of consumables for printers (Date, Printer Name, Description, Cost), 2) Contains list of consumables and their current cost ($). This is what I currently have done. Sheet 1 contains a validation list for the Printer Name and Description fields. These are retrieved from Sheet 2 via to named ranges (Printers & Supplies). On Sheet 1 in the Cost column I have a VLOOKUP to automatically insert the current cost of the supply (ex. =IF(C4="","",VLOOKUP(C4,SupplyLookup,2,FALSE)) ). Here is my problem. When I update the current cost of the supplies on Sheet 2, the costs are reflected on all related fields on Sheet 1. This is not my desired result. I would like to be able to select the supply from a drop down list, have the cost inserted from Sheet 2, but only for new rows not previously recorded rows. Please help... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List & VLOOKUP
On Dec 19, 2:24 pm, Joel wrote:
Why don't you add a date when the new rows are added into sheet? Then include the date in the IF statement one sheet one. Use the date to determine the new rows. "j@ckle" wrote: I have a question and I hope someone can help. I have two spreadsheets. 1) Contains a history of consumables for printers (Date, Printer Name, Description, Cost), 2) Contains list of consumables and their current cost ($). This is what I currently have done. Sheet 1 contains a validation list for the Printer Name and Description fields. These are retrieved from Sheet 2 via to named ranges (Printers & Supplies). On Sheet 1 in the Cost column I have a VLOOKUP to automatically insert the current cost of the supply (ex. =IF(C4="","",VLOOKUP(C4,SupplyLookup,2,FALSE)) ). Here is my problem. When I update the current cost of the supplies on Sheet 2, the costs are reflected on all related fields on Sheet 1. This is not my desired result. I would like to be able to select the supply from a drop down list, have the cost inserted from Sheet 2, but only for new rows not previously recorded rows. Please help... I have the date entered in Column A. The only problem is if I include the date to the IF statement any previous entry the cost (Column C) is blank. Unless I am just not checking the date properly. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List & VLOOKUP
=IF(C4="","",if(date()=VLOOKUP(C4,SupplyLookup,1,F ALSE),VLOOKUP(C4,SupplyLookup,2,FALSE),"")
"j@ckle" wrote: On Dec 19, 2:24 pm, Joel wrote: Why don't you add a date when the new rows are added into sheet? Then include the date in the IF statement one sheet one. Use the date to determine the new rows. "j@ckle" wrote: I have a question and I hope someone can help. I have two spreadsheets. 1) Contains a history of consumables for printers (Date, Printer Name, Description, Cost), 2) Contains list of consumables and their current cost ($). This is what I currently have done. Sheet 1 contains a validation list for the Printer Name and Description fields. These are retrieved from Sheet 2 via to named ranges (Printers & Supplies). On Sheet 1 in the Cost column I have a VLOOKUP to automatically insert the current cost of the supply (ex. =IF(C4="","",VLOOKUP(C4,SupplyLookup,2,FALSE)) ). Here is my problem. When I update the current cost of the supplies on Sheet 2, the costs are reflected on all related fields on Sheet 1. This is not my desired result. I would like to be able to select the supply from a drop down list, have the cost inserted from Sheet 2, but only for new rows not previously recorded rows. Please help... I have the date entered in Column A. The only problem is if I include the date to the IF statement any previous entry the cost (Column C) is blank. Unless I am just not checking the date properly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and drop down list | Excel Discussion (Misc queries) | |||
vlookup (a drop list) | Excel Discussion (Misc queries) | |||
Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
Drop Down List + VLOOKUP | Excel Worksheet Functions |