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.