Vlookup Help

[JLouis]

I am trying to lookup a value in a separate workbook whose value contains a forward slash. The lookup value is "Total Disc / Coup" and the lookup doesn't work with the forward slash in it.

Here's formula:
=VLOOKUP("Total Disc / Coup",'C:\FH276 QB WEEKLY 2017\Royalty\[report.xls]sheet1'!$A$1:$N$50,14,FALSE)

Thanks for any assistance.

 

[Aladin Akyurek]

BTW, I went to my laptop and was able to do as you say across two workbooks without problem. I am exporting the sheet off the internet in xls format. Would that affect the behavior of the worksheet?

Perhaps, I don't know...

Does this help?

=VLOOKUP(SUBSTITUTE("Total Disc / Coup"," ",CHAR(180)),'C:\FH276 QB WEEKLY 2017\Royalty\[report.xls]sheet1'!$A$1:$N$50,14,FALSE)

 

[JLouis]

Aladin, I really appreciate you spending time on this.

The formula returned a #N/A error code. I also took the file from the internet, Report.xls, and saved it as an xlsx file without success. The next thing I'm going to try is to move the exact files I'm using on my PC to the laptop and report the results. I'm using Excel 365 on both computers. I'm wondering if it's a setting or something.

 

[JLouis]

Found out there is another coup / disc entry on this spreadsheet and my formula was reading the wrong entry. Everything works. I apologize for not doing my due diligence before posting and will make sure I do in the future. I have accomplished a lot over the years using this site as a resource.

Thanks again.

 

[Aladin Akyurek]

Found out there is another coup / disc entry on this spreadsheet and my formula was reading the wrong entry. Everything works. I apologize for not doing my due diligence before posting and will make sure I do in the future. I have accomplished a lot over the years using this site as a resource.

Thanks again.

No problem. Great that it's resolved. Thanks for the update.