Hi I want to create a file where in I want to keep the formula and allow text in the same cell but basis drop-down. I am attaching my sheet for reference. Column C has a drop-down where I have 2 values A and B. If I select A, then the formula will auto populate the data from M3:R4 in columns D:H. But if I select B, then I will have the option to enter values from D:H manually without deleting the formula. Again, if I select A then my formula should pull the data from M3:R4. Thanks in advance
Using same cell as formula and custom text as per dropdown
- bantrully
- Thread is marked as Resolved.
-
-
-
Which cell contains the formula? It cannot be C.
-
Column D:H contains the formula..
-
So what's the problem? When you change column C then the VLOOKUP should update, except there is nothing to lookup for B
-
When I will select B in column C4 it should allow me to enter number/text manually without deleting the formula. Currently, if I select B in C4 and enter any number manually then the Vlookup formula will get deleted and when I again select A in C4 the Vlookup will not work.
-
You cannot type into a cell cell without deleting the formula.
-
Is there any Macro that can help me with both conditions? As in if I select A in C4 then the specific Vlookup formula will run and if I select B in C4 then it will allow me to type without changing the formula.
-
Any help from anyone?
-
What you are asking is not worth the effort.
Any code would need to be able to restore the existing formula, but you cannot store the formula after the code has run.
Why do you nwwd this? You could write an IF function to include the VLOOKUP or allow input from a cell.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!