I have one cell (C33) that has a list validation attached to it. The list
(column A on a separate sheet called Data_text) is a series of text
statements that the user can select from the drop drown.

I have a second cell (C44) that has a Vlookup formula based on the contents
of the first cell (C33). The Vlookup formula returns the text in column B
(from the same list, Data_txt) from the selection made in column A (or what
is now in C33)

Both cells have only text values.

I need to assign the returned Vlookup value to C44 but I dont want to put
the Vlookup formula in it. This is because the user may need to edit the text
that is brought back by the Vlookup and of course when you go to edit the
cell you end up editing the formula.

I have tried assigning the Vlookup formula to a named range (the second cell
C44), however I cant seem to use that named range in any way to get it to
simply put the returned value in the second cell.

Is there a way to have the list validation also return the text in column B
into the second cell?

I am afraid that I may have to go to VBA a solution.

I hope I have explained this correctly, any help would be greatly appreciated

--
Bill

Why don't you unlock input cells and protect the worksheet?

--
Regards!
Stefi



€žWFariss€� ezt Ã*rta:

I have one cell (C33) that has a list validation attached to it. The list
(column A on a separate sheet called Data_text) is a series of text
statements that the user can select from the drop drown.

I have a second cell (C44) that has a Vlookup formula based on the contents
of the first cell (C33). The Vlookup formula returns the text in column B
(from the same list, Data_txt) from the selection made in column A (or what
is now in C33)

Both cells have only text values.

I need to assign the returned Vlookup value to C44 but I dont want to put
the Vlookup formula in it. This is because the user may need to edit the text
that is brought back by the Vlookup and of course when you go to edit the
cell you end up editing the formula.

I have tried assigning the Vlookup formula to a named range (the second cell
C44), however I cant seem to use that named range in any way to get it to
simply put the returned value in the second cell.

Is there a way to have the list validation also return the text in column B
into the second cell?

I am afraid that I may have to go to VBA a solution.

I hope I have explained this correctly, any help would be greatly appreciated

--
Bill

I will do that at a later time.
--
Bill


"Stefi" wrote:

Why don't you unlock input cells and protect the worksheet?

--
Regards!
Stefi



€žWFariss€� ezt Ã*rta:

I have one cell (C33) that has a list validation attached to it. The list
(column A on a separate sheet called Data_text) is a series of text
statements that the user can select from the drop drown.

I have a second cell (C44) that has a Vlookup formula based on the contents
of the first cell (C33). The Vlookup formula returns the text in column B
(from the same list, Data_txt) from the selection made in column A (or what
is now in C33)

Both cells have only text values.

I need to assign the returned Vlookup value to C44 but I dont want to put
the Vlookup formula in it. This is because the user may need to edit the text
that is brought back by the Vlookup and of course when you go to edit the
cell you end up editing the formula.

I have tried assigning the Vlookup formula to a named range (the second cell
C44), however I cant seem to use that named range in any way to get it to
simply put the returned value in the second cell.

Is there a way to have the list validation also return the text in column B
into the second cell?

I am afraid that I may have to go to VBA a solution.

I hope I have explained this correctly, any help would be greatly appreciated

--
Bill

To stick a value in C44 without a formula in C44 you will need VBA.


Gord Dibben MS Excel MVP

On Tue, 16 Feb 2010 08:06:01 -0800, WFariss wrote:

I will do that at a later time.

I was afraid of that, thanks.
--
Bill


"Gord Dibben" wrote:

To stick a value in C44 without a formula in C44 you will need VBA.


Gord Dibben MS Excel MVP

On Tue, 16 Feb 2010 08:06:01 -0800, WFariss wrote:

I will do that at a later time.

.