use v lookup from a drop down list
 

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.

use v lookup from a drop down list
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in message
...
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.

use v lookup from a drop down list
 

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" wrote:

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in message
...
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.

use v lookup from a drop down list
 

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)


--
Biff
Microsoft Excel MVP


"Retired Bill" wrote in message
...
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" wrote:

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in message
...
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.

use v lookup from a drop down list
 

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

"T. Valko" wrote:

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)


--
Biff
Microsoft Excel MVP


"Retired Bill" wrote in message
...
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" wrote:

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in message
...
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.

use v lookup from a drop down list
 

Let me know how you make out.

--
Biff
Microsoft Excel MVP


"Retired Bill" wrote in message
...
Thanks, I shall give it a try, I appreciate your time

"T. Valko" wrote:

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)


--
Biff
Microsoft Excel MVP


"Retired Bill" wrote in message
...
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" wrote:

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in
message
...
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.