use v lookup from a drop down list

[Retired Bill]

I have a colmun in my main worksheet that I use a drop down list in. I want
to select something from the drop down list on the main worksheet, BUT have
it return a different value from another column in my list worksheet. I
have set up the list worksheet to have the drop down items in column A, and
the value I want in the same row in column C.

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html

 

[Retired Bill]

Thanks, but unless I did not see it, I do not see anywhere in this link that
talks about using a lookup value from a drop down list. Becasue I am new to
Excel, I might not have stated my problem very well. Let Me Try Again - - -
-
I have a worksheet with several columns
In one column I have created a drop down listing, for the entire column
being used
On another worksheet in the same workbook I have created the list
Column A contains the drop down "picks" if you will
Column B contains the value I want to be entered from the pick in column A
located in the same row
when I pick an entry from the drop down listing I want it to return the
value from column b
i, e, > COLUMN "A" COLUMN "B"
1 A
2 Q
3 Z
If I select from the drop down list the pick of 2, when I click on that
entry it will return the value of Q in that cell
did I say it better this time, thanks for your help

 

[T. Valko]

What kind of drop down list are you using? There are 3 kinds. If you're
using a data validation list then the technique described in the link will
work.

I'll go through it again just in case...

Let's assume you have this list on Sheet2 in the range A1:B3:

...........A..........B
1........1..........A
2........2..........Q
3........3..........Z

On Sheet1 cell A1 you have a data validation list with these selections: 1,
2, 3

Enter this formula on Sheet1 in cell B1:

=VLOOKUP(A1,Sheet2!A$1:B$3,2,0)

 

[Retired Bill]

Thanks, I shall give it a try, I appreciate your time

 

[T. Valko]

Let me know how you make out.