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 cell
for the drop down list are populated by a vlookup depending on what i
typed in cell A1. I need whatever is selected from the dropdown lis
to be populated in a different cell on a different worksheet. Doe
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]

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

Thanks!

Lise

 

[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
(e-mail address removed). Remove the "nop" from this address. HTH Otto