Dropdownlist and Vlookup

[Mohamed72]

Hi,
In the attached spreadsheet, i created a dropdownlist consisting of
associates` items (Nermine, Heba and Mohamed) and used the Vlooku
function to lookup for the data of each item. Now i`ve got tw
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 ?
Regard

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

 

[Spencer101]

Hi,
In the attached spreadsheet, i created a dropdownlist consisting of
associates` items (Nermine, Heba and Mohamed) and used the Vlooku
function to lookup for the data of each item. Now i`ve got tw
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 i
will be far easier to help you

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[shanermuls]

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

You can zip it first and then upload the zip fil

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[CellShocked]

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.

 

[Mohamed72]

On Sun, 24 Feb 2013 11:14:59 +0000, Mohamed72



When you make the "table" which contains the items you wish to use i
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 name
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 attache
spreadsheet?
Best regard

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=781
+-------------------------------------------------------------------

 

[CellShocked]

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.

 

[Mohamed72]

On Mon, 25 Feb 2013 06:58:28 +0000, Mohamed72



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 solve

+-------------------------------------------------------------------
+-------------------------------------------------------------------