Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dropdownlist and Vlookup
Hi,
In the attached spreadsheet, i created a dropdownlist consisting of 3 associates` items (Nermine, Heba and Mohamed) and used the Vlookup function to lookup for the data of each item. Now i`ve got two problems: 1- How can i add and enter ( payed) column for each item ? 2- How can i calculate the sum of payed price for each associate ? Regards |
#2
|
|||
|
|||
Quote:
If you attach an actual workbook rather than pictures of a workbook it will be far easier to help you. |
#3
|
|||
|
|||
I tried to upload the xls file but it i didn`t work
|
#4
|
|||
|
|||
You can zip it first and then upload the zip file
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdownlist and Vlookup
On Sun, 24 Feb 2013 11:14:59 +0000, Mohamed72
wrote: Hi, In the attached spreadsheet, i created a dropdownlist consisting of 3 associates` items (Nermine, Heba and Mohamed) and used the Vlookup function to lookup for the data of each item. Now i`ve got two problems: 1- How can i add and enter ( payed) column for each item ? 2- How can i calculate the sum of payed price for each associate ? Regards +-------------------------------------------------------------------+ |Filename: sample1.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=777| |Filename: sample 2.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=778| |Filename: sample 3.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=779| +-------------------------------------------------------------------+ When you make the "table" which contains the items you wish to use in a drop-down list, you should give the table a range name, then your list criteria would simply refer to that range name as in: =table_name_here Then, any columns or rows you add to the worksheet will adjust the location of that named range auto-magically. Of course your named range replaces "table_name_here". I keep my lookup list tables on separate worksheets. For the tally results you should create and use a pivot table. |
#6
|
|||
|
|||
Quote:
I`m not following , would you kindely illustrate this in the attached spreadsheet? Best regards |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdownlist and Vlookup
On Mon, 25 Feb 2013 06:58:28 +0000, Mohamed72
wrote: CellShocked;1609714 Wrote: On Sun, 24 Feb 2013 11:14:59 +0000, Mohamed72 wrote: - Hi, In the attached spreadsheet, i created a dropdownlist consisting of 3 associates` items (Nermine, Heba and Mohamed) and used the Vlookup function to lookup for the data of each item. Now i`ve got two problems: 1- How can i add and enter ( payed) column for each item ? 2- How can i calculate the sum of payed price for each associate ? Regards +-------------------------------------------------------------------+ |Filename: sample1.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=777| |Filename: sample 2.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=778| |Filename: sample 3.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=779| +-------------------------------------------------------------------+- When you make the "table" which contains the items you wish to use in a drop-down list, you should give the table a range name, then your list criteria would simply refer to that range name as in: =table_name_here Then, any columns or rows you add to the worksheet will adjust the location of that named range auto-magically. Of course your named range replaces "table_name_here". I keep my lookup list tables on separate worksheets. For the tally results you should create and use a pivot table. Hi Cellshock, I`m not following , would you kindely illustrate this in the attached spreadsheet? Best regards +-------------------------------------------------------------------+ |Filename: sample.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=781| +-------------------------------------------------------------------+ This probably isn't what you want either, but... http://www.mediafire.com/view/?2bmnk07a19761wy I did not perform any summing maybe after work today. |
#8
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DropdownList/AutoFillUpList | Excel Discussion (Misc queries) | |||
dropdownlist - inputbox | Excel Programming | |||
Aligment of DropDownList | Excel Programming | |||
Aligment of DropDownList | Excel Programming | |||
Dropdownlist in a Cell | Excel Programming |