Question description:
This user has given permission to use the problem statement for this
blog.
I used vlookup for my excel sheet to match different cells using another sheet for reference. Now when I try to edit the new cells, it just shows my vlookup formula and wont let me edit anything unless i change edit it from the reference sheet. Wanted to know if i can make it so the cell isn't binded to a formula anymore and is its own cell where i can edit.
Thank you.
Solved by D. W. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
17/07/2018 - 04:35
Hi
Welcome to Gotit pro.
User
17/07/2018 - 04:35
hi
Excelchat Expert
17/07/2018 - 04:35
How can I help you?
User
17/07/2018 - 04:35
I used vlookup for my excel sheet to match different cells using another sheet for reference. Now when I try to edit the new cells, it just shows my vlookup formula and wont let me edit anything unless i change edit it from the reference sheet. Wanted to know if i can make it so the cell isn't binded to a formula anymore and is its own cell where i can edit.
Excelchat Expert
17/07/2018 - 04:36
ok can i have your data so we can check on it
User
17/07/2018 - 04:36
well the datas are confidential but i can show you my problem on the document preview
User
17/07/2018 - 04:37
so for example
Excelchat Expert
17/07/2018 - 04:37
oh ok
User
17/07/2018 - 04:39
see thats the problem
User
17/07/2018 - 04:39
now for sheet2
User
17/07/2018 - 04:39
i cant edit the values
User
17/07/2018 - 04:39
it just shows as formula
Excelchat Expert
17/07/2018 - 04:39
wait ill check
User
17/07/2018 - 04:39
i need it so i can edit it without sheet1 being there
User
17/07/2018 - 04:40
i was wondering if there is a way to unbind the formula from sheet1 to make it a separate sheet
Excelchat Expert
17/07/2018 - 04:40
you are doing the vlookup and getting the data ion sheet1?
User
17/07/2018 - 04:40
yes
User
17/07/2018 - 04:41
i used data from sheet1 and matched it with the names on sheet 2
Excelchat Expert
17/07/2018 - 04:41
and then which on you cant edit?
Excelchat Expert
17/07/2018 - 04:41
one*
User
17/07/2018 - 04:42
well so for example
User
17/07/2018 - 04:42
sheet2
User
17/07/2018 - 04:42
what if i wanna change it to 26
Excelchat Expert
17/07/2018 - 04:43
you want to change 26 where?
Excelchat Expert
17/07/2018 - 04:43
on macy?
User
17/07/2018 - 04:43
sheet2 B1
User
17/07/2018 - 04:43
yes
User
17/07/2018 - 04:43
because right now, i am just using numbers for simplicity but for mine, i have paragraphs
User
17/07/2018 - 04:44
and i want to be able to edit the paragraphs
Excelchat Expert
17/07/2018 - 04:44
but you have a formula there right, if you change it as 26 so it will be overwrite
User
17/07/2018 - 04:44
well i know that i can change it one sheet1
User
17/07/2018 - 04:44
when i change it on sheet1, it changes on sheet2
User
17/07/2018 - 04:44
but i need a way to be able to change it on sheet2
Excelchat Expert
17/07/2018 - 04:45
yes
Excelchat Expert
17/07/2018 - 04:45
you want only the value in sheet2?
Excelchat Expert
17/07/2018 - 04:45
remain
User
17/07/2018 - 04:45
yes
Excelchat Expert
17/07/2018 - 04:45
even you change the values in sheet1?
User
17/07/2018 - 04:45
here another example
Excelchat Expert
17/07/2018 - 04:46
ok :)
User
17/07/2018 - 04:46
so try change "i love my mom" to "i love my dad" without using sheet1
User
17/07/2018 - 04:46
because at the end of this project, i have to delete sheet1 and if i do that, everything becomes an error since the formula is linked to sheet1
Excelchat Expert
17/07/2018 - 04:47
ok i get it
Excelchat Expert
17/07/2018 - 04:47
you may use the Paste special here
Excelchat Expert
17/07/2018 - 04:47
after doing the vlookup
Excelchat Expert
17/07/2018 - 04:48
so you can copy the actual value instead of the formula
Excelchat Expert
17/07/2018 - 04:48
like this one
Excelchat Expert
17/07/2018 - 04:48
here it is
User
17/07/2018 - 04:48
well ofc i can copy and paste when it is just 3 data
User
17/07/2018 - 04:48
i am working with thousands of data
User
17/07/2018 - 04:49
that's why i used vlookup
Excelchat Expert
17/07/2018 - 04:49
yes you still use the paste special even it was a thousand
Excelchat Expert
17/07/2018 - 04:49
first you will just use the vlookup
Excelchat Expert
17/07/2018 - 04:50
after getting all the values select it again
Excelchat Expert
17/07/2018 - 04:50
then use the paste special
Excelchat Expert
17/07/2018 - 04:50
then values, to remain all you values there and remove the formula
Excelchat Expert
17/07/2018 - 04:50
i will show you how
User
17/07/2018 - 04:51
ahhhhh
User
17/07/2018 - 04:51
GOT IT!
User
17/07/2018 - 04:52
I see what you did
User
17/07/2018 - 04:52
thank you
Excelchat Expert
17/07/2018 - 04:52
nice
Excelchat Expert
17/07/2018 - 04:52
does it work for you now?
User
17/07/2018 - 04:52
yes it does
Excelchat Expert
17/07/2018 - 04:52
awesome
User
17/07/2018 - 04:52
thank you so much
Excelchat Expert
17/07/2018 - 04:52
have i answered your question now?
User
17/07/2018 - 04:53
yes sir
Excelchat Expert
17/07/2018 - 04:53
wonderful
Excelchat Expert
17/07/2018 - 04:53
Is there anything else I can help you with?
User
17/07/2018 - 04:53
no
User
17/07/2018 - 04:53
thats it
Excelchat Expert
17/07/2018 - 04:53
ok
Excelchat Expert
17/07/2018 - 04:53
Thank you for chatting with us.
If you don't mind, can i ask your kind feedback on our service after you end our session?.Have a lovely day!