Question description:
This user has given permission to use the problem statement for this
blog.
I need help with vlookup. I need to move data from 'wk1' E to 'Destination sheet'AT if helper columns G match. Also I do not want to erase any data that is currently in the cell.
Solved by G. Q. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/08/2018 - 02:59
Hi there
User
14/08/2018 - 02:59
hi
Excelchat Expert
14/08/2018 - 02:59
How are you and how may i assist you with today?
User
14/08/2018 - 03:00
let me copy some data. one minute
Excelchat Expert
14/08/2018 - 03:00
Yep sure please go ahead
User
14/08/2018 - 03:03
I need help with vlookup. I need to move data from 'wk1' E to 'Destination sheet'AT if helper columns G match. Also I do not want to erase any data that is currently in the cell.
Excelchat Expert
14/08/2018 - 03:03
Okay, i will try my best to help you out with this
Excelchat Expert
14/08/2018 - 03:06
Just to let you know that i can help you with vlookup but seems like to erase the data found you would help of VBA/Macro coding
Excelchat Expert
14/08/2018 - 03:06
But I really apologise saying this that we dont support in VBA/Macro coding as of now :)
User
14/08/2018 - 03:07
can vlookup only insert data if data is found and not put in anything if no data is found?
Excelchat Expert
14/08/2018 - 03:08
Yep, vlookup can only look up and return the corresponding value
User
14/08/2018 - 03:08
that should be fine
User
14/08/2018 - 03:09
This is what I thought it should be, but it didn't work =VLOOKUP(G3,wk1!G:AT,5,FALSE)
Excelchat Expert
14/08/2018 - 03:10
You need the values of G to goto the 1st sheet, right?
Excelchat Expert
14/08/2018 - 03:11
And i dont see column AT in wk1 sheet?
User
14/08/2018 - 03:11
If G matches on the two sheets, I need the data from 'wk1'E to be copied onto 'Destination sheet'
User
14/08/2018 - 03:12
that is because AT is on the Destination sheet
Excelchat Expert
14/08/2018 - 03:14
the corresponding value(like here column E) should be present towards the right of the lookup value(Column G)
Excelchat Expert
14/08/2018 - 03:14
Thats how vlookup works :)
Excelchat Expert
14/08/2018 - 03:15
check the column H in added clone of column E
Excelchat Expert
14/08/2018 - 03:16
Which column in destination sheet we need to match with?
User
14/08/2018 - 03:17
I need column G to match before we move data from E in Wk1 to AT in the Destination sheet
Excelchat Expert
14/08/2018 - 03:18
Yep column G should match with which column in "Destination sheet" ?
User
14/08/2018 - 03:19
with G
Excelchat Expert
14/08/2018 - 03:19
Cool
Excelchat Expert
14/08/2018 - 03:21
Please see column AT now, i have done the formula there
Excelchat Expert
14/08/2018 - 03:23
Is it good?
User
14/08/2018 - 03:23
is what good?
Excelchat Expert
14/08/2018 - 03:24
The vlookup formula in column AT
User
14/08/2018 - 03:24
I just see #N/A
Excelchat Expert
14/08/2018 - 03:25
Yep, because there are no matching values found in column G of both the sheets :)
User
14/08/2018 - 03:26
Then it writes over what I have in the cell
Excelchat Expert
14/08/2018 - 03:26
Did you get it?
User
14/08/2018 - 03:26
I want it to leave the data in the cell alone if there is no match
Excelchat Expert
14/08/2018 - 03:27
Cool, will do that for you. If no match found it should leave the cell blank, right?
Excelchat Expert
14/08/2018 - 03:28
Is it good now?
Excelchat Expert
14/08/2018 - 03:29
Try by inserting some matching values in column G and please confirm
User
14/08/2018 - 03:29
1 minute
Excelchat Expert
14/08/2018 - 03:30
Sure i will wait here :)
User
14/08/2018 - 03:31
No it is not working. But we are out of time. Thanks for trying.
Excelchat Expert
14/08/2018 - 03:32
It will wait i will show you up
User
14/08/2018 - 03:32
it covers over what i have with an -
User
14/08/2018 - 03:32
So any data in the cell is replaced with a -
Excelchat Expert
14/08/2018 - 03:33
No if there is no match found then it will replace with -
User
14/08/2018 - 03:33
I understand, but if there is no match found I want it to leave the cell alone and do nothing
Excelchat Expert
14/08/2018 - 03:34
See as its getting a matching value its giving "yes"
Excelchat Expert
14/08/2018 - 03:34
Now its blank
Excelchat Expert
14/08/2018 - 03:34
Is it good now?
User
14/08/2018 - 03:36
No
Excelchat Expert
14/08/2018 - 03:36
May i know how?
User
14/08/2018 - 03:37
first it is using the data from H not E and when in does not find a match it replaces the data in the cell with a -
Excelchat Expert
14/08/2018 - 03:37
"AbigailOwens" is matching with both the column G of both sheet so we are getting "Yes" for it
User
14/08/2018 - 03:38
Thanks any way. I appreciate you trying. I will still leave a good review.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.