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

Hi Mohamed,

If you attach an actual workbook rather than pictures of a workbook it will be far easier to help you.

I tried to upload the xls file but it i didn`t work

You can zip it first and then upload the zip file

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.

Hi Cellshock,
I`m not following , would you kindely illustrate this in the attached spreadsheet?
Best regards

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.

Deep Thanks Cellshock , the problem solved