Thread: VLookup - Error when using text pulled from another sheet

What I am trying to involves 3 workbooks.

Workbook #1
Contains raw data and the necessary info which is text, like "Northeast" or "America East".

Workbook#2
The info from workbook #1 is aggregated into workbook #2 along with other info.

Workbook #3
Text with corresponding numbers which is serving as the vlookup range.
Like this:
America East 1.00
Southern 1.05
Northeast 1.10

I am trying to get the Number value from Workbook #3 to display next to the text if it is appearing in #2.

So what I though would work is: =vlookup(CB16,'[Workbook #3.xls]Sheet1$B$12:$C$44,2,FALSE)

Workbook #3 is that table listed above, CB16 is the cell containing "America East".
The problem is that CB16 doesn't just have the text "America East", it contains the formula ='[Workbook#1.xls]Sheet 1'!$A1

So the issue is that it is trying to use a formula instead of just text as the vlookup, because when i just type America East into that cell, it works fine.

Help!

Good Call.. It does have a trailing space, but this info is automatically generated so i can't remove the trailing spaces. Is there a way to work the formula around that?

Yahtzee!

Trim worked. Thanks a lot!