Excel - How to Use a VLOOKUP Formula - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, I have a problem with vlookup formula, I am not sure what am I doing wrong but it seems to not be working
Solved by K. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/10/2018 - 12:21
Hi
Excelchat Expert 15/10/2018 - 12:21
How can i help you?
User 15/10/2018 - 12:21
hello
User 15/10/2018 - 12:21
I ll send u a file and see if u can help me
Excelchat Expert 15/10/2018 - 12:21
Please share the file and problem with the vlookup formula
Excelchat Expert 15/10/2018 - 12:22
Sure
User 15/10/2018 - 12:22
[Uploaded an Excel file]
User 15/10/2018 - 12:22
let me know when you have the file opened
Excelchat Expert 15/10/2018 - 12:22
I have downloaded the file successfully
Excelchat Expert 15/10/2018 - 12:23
Can you please elaborate what you have been trying to achieve
Excelchat Expert 15/10/2018 - 12:23
?
User 15/10/2018 - 12:23
so, I have a vlookup formula in sheet *bleached softwood*
User 15/10/2018 - 12:23
column D
User 15/10/2018 - 12:23
and the lookup table is in sheet2
Excelchat Expert 15/10/2018 - 12:23
Okay
User 15/10/2018 - 12:23
and I do not know what is the problem
User 15/10/2018 - 12:24
since i get that N/A error
Excelchat Expert 15/10/2018 - 12:25
I have a solution to the problem. And its fixed
User 15/10/2018 - 12:25
tell me
User 15/10/2018 - 12:25
what was it
User 15/10/2018 - 12:25
?
Excelchat Expert 15/10/2018 - 12:25
=IFERROR(VLOOKUP(A7,Sheet2!$B$2:$D$17,3,0),"-") would work
User 15/10/2018 - 12:25
let me give it a try
Excelchat Expert 15/10/2018 - 12:25
I am sending you the file with updated file now
Excelchat Expert 15/10/2018 - 12:26
PFA
[Uploaded an Excel file]
Excelchat Expert 15/10/2018 - 12:26
Please let me know if this was the desired solution you required?
User 15/10/2018 - 12:27
let me see
Excelchat Expert 15/10/2018 - 12:27
Sure
Excelchat Expert 15/10/2018 - 12:28
Here, you had to actually freeze the range in the formula.
User 15/10/2018 - 12:28
I still get nothing
User 15/10/2018 - 12:28
is there a problem if i am tryin to look up from a range in a pivot table
User 15/10/2018 - 12:28
because I just copied a part of it to give as a sample to u
User 15/10/2018 - 12:29
?
Excelchat Expert 15/10/2018 - 12:29
did you check the file?
User 15/10/2018 - 12:29
I did
User 15/10/2018 - 12:29
and I did the same now in my original file
Excelchat Expert 15/10/2018 - 12:29
let me check
User 15/10/2018 - 12:29
freezed the range but I don't get anything
Excelchat Expert 15/10/2018 - 12:32
So the problem here is not all the "Consignee Code" have a mapping in sheet2
User 15/10/2018 - 12:32
I get your point
Excelchat Expert 15/10/2018 - 12:33
Like "3100000209" doesn;t have a mapping in sheet2
Excelchat Expert 15/10/2018 - 12:33
so for sure you'll get a null
User 15/10/2018 - 12:33
and I see that you have gotten some answers and I achieved the same when I tried
Excelchat Expert 15/10/2018 - 12:33
or N/A
Excelchat Expert 15/10/2018 - 12:33
Okay
User 15/10/2018 - 12:33
but the thing is that I have many ranges that I have to do the lookup for
User 15/10/2018 - 12:33
and those ranges are part of a pivot table and the problem seems to be that I cannot lookup from a pivot
Excelchat Expert 15/10/2018 - 12:33
Fine... So wheres the pivot table?
User 15/10/2018 - 12:34
because when I do even if I follow the steps that you suggested it doesnt return anything
User 15/10/2018 - 12:34
not even those that are part of the range
Excelchat Expert 15/10/2018 - 12:34
is the pivot in the same excel file you shared?
User 15/10/2018 - 12:34
the pivot would not be working if I sent it to you because it is from an Online cube and
Excelchat Expert 15/10/2018 - 12:34
okay
User 15/10/2018 - 12:34
you would not have access to it
User 15/10/2018 - 12:34
just thought if you could help with it
Excelchat Expert 15/10/2018 - 12:35
i can help you out if you share some sample data of it atleast
User 15/10/2018 - 12:37
what I sent u was a sample data..
Excelchat Expert 15/10/2018 - 12:37
in case you have many ranges you could use something like iferror(vlook(VLOOKUP(row,Range1,column,FALSE),iferror(vlook(VLOOKUP(row,Range2,column,FALSE),"")
Excelchat Expert 15/10/2018 - 12:38
Ignore the last formula iferror(VLOOKUP(row,Range1,column,FALSE),iferror(vlook(VLOOKUP(row,Range2,column,FALSE),"")
Excelchat Expert 15/10/2018 - 12:38
something of this sort would be useful
Excelchat Expert 15/10/2018 - 12:39
or copy all the ranges to a single sheet and apply a single vlookup
Excelchat Expert 15/10/2018 - 12:39
I hoep this solves your problem
User 15/10/2018 - 12:40
thanks
Excelchat Expert 15/10/2018 - 12:40
Have a nice day . Please visit us again.

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.