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