**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!