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