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

[liseladele]

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!

[Otto Moehrbach]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[liseladele]

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

[Otto Moehrbach]

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
[email protected]. Remove the "nop" from this address. HTH Otto
"liseladele" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>