Excel - How to Use a VLOOKUP Formula - Expert Solution

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!
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.