All solutions HelpVLOOKUP Expert Solution – Help on VLOOKUP Problems

Excel - Help on VLOOKUP Problem - Expert Solution

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
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
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
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.

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.

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc