Value selected on drop down list, look-up on different sheet
 

Hi...I need some help.

I have a drop down list on my spreadsheet. The values within the cells
for the drop down list are populated by a vlookup depending on what is
typed in cell A1. I need whatever is selected from the dropdown list
to be populated in a different cell on a different worksheet. Does
anybody have any idea how to do that??

Thanks!


--
liseladele
------------------------------------------------------------------------
liseladele's Profile: http://www.excelforum.com/member.php...o&userid=32688
View this thread: http://www.excelforum.com/showthread...hreadid=525002

Value selected on drop down list, look-up on different sheet
 

If this other cell on the other sheet is always the same cell, just put a
formula in that cell that is something like:
=FirstSheetName!E1
Where E1 is the drop-down cell.
If the destination cell is not always the same cell, post back and tell us
how the cell changes. For instance, is it the first empty cell in some
column? HTH Otto
"liseladele" wrote
in message ...

Hi...I need some help.

I have a drop down list on my spreadsheet. The values within the cells
for the drop down list are populated by a vlookup depending on what is
typed in cell A1. I need whatever is selected from the dropdown list
to be populated in a different cell on a different worksheet. Does
anybody have any idea how to do that??

Thanks!


--
liseladele
------------------------------------------------------------------------
liseladele's Profile:
http://www.excelforum.com/member.php...o&userid=32688
View this thread: http://www.excelforum.com/showthread...hreadid=525002

Value selected on drop down list, look-up on different sheet
 

Unfortunately it is different everytime...so the A1 on Sheet 1 will be
different the cell A1 on Sheet 2, which makes every drop down list
different. Any advice?

Thanks!

Lisel


--
liseladele
------------------------------------------------------------------------
liseladele's Profile: http://www.excelforum.com/member.php...o&userid=32688
View this thread: http://www.excelforum.com/showthread...hreadid=525002

Value selected on drop down list, look-up on different sheet
 

The A1 value in Sheet1 drives the VLOOKUP formulas which in turn generate
the values for the drop-down list. From what you say you are interested
only in copying what is selected in the drop-down list to some place. As I
see it, the changes in A1 of Sheet1 have nothing to do with your question.
Let's call the cell into which you want the value selected in the drop-down
list pasted, the destination cell. Now tell me what the destination cells
is. If it keeps changing, tell me what is making it change. There has to
be a logic to this. What is the logic?
You say "which makes every drop down list different." This is the first
you have said about there being more than one drop-down list. Where are all
the drop-down lists and where are the lists of values that are displayed by
these drop-down lists?
It might be easier if you send me your file or an example of your file
so that I can see what you have. Include a clear explanation, with
examples, of what you want to happen. My email address is
. Remove the "nop" from this address. HTH Otto
"liseladele" wrote
in message ...

Unfortunately it is different everytime...so the A1 on Sheet 1 will be
different the cell A1 on Sheet 2, which makes every drop down list
different. Any advice?

Thanks!

Lisel


--
liseladele
------------------------------------------------------------------------
liseladele's Profile:
http://www.excelforum.com/member.php...o&userid=32688
View this thread: http://www.excelforum.com/showthread...hreadid=525002