How can I assign a value to a cell without putting a formula in it


W

WFariss

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 don’t 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 can’t 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
 
Ad

Advertisements

S

Stefi

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

--
Regards!
Stefi



„WFariss†ezt írta:
 
W

WFariss

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


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

--
Regards!
Stefi



„WFariss†ezt írta:
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top