Using vlookup to pull data from another workbook

[ToyMiller]

I have been trying to get this to work and to no avail....

=IFERROR(VLOOKUP(H5,'C:\folder*\Folder*\Folder*\Folder*\[Auctions Offered Template.xlsx]Auction Offered'!$D$3:$G$33,2,FALSE),"")

The Folder* is just a placeholder for my file path.

I get a result 0. However that is not the answer.

Is my statement incorrect here?

I have the sheet that I am in and I am using the formula to get the data from another sheet with a pivot table.

Any help would be appreciated.

_T

 

[DanteAmor]

What do you have in cell H5, if you have a number, in column D of the other sheet you must have numbers.

 

[ToyMiller]

What do you have in cell H5, if you have a number, in column D of the other sheet you must have numbers.

Yes, It I a txt that is looking at the txt in the other sheet and pulling a number from the other sheet.

Why does that matter? I am getting a result, it is not the right result.

 

[DanteAmor]

You have to check if there are spaces before or after the text.

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.