My table array is $B$7:$N$58... I copied the wrong formula.

"Rapunzel" wrote:

Hello,

I am trying to use VLOOKUP to cross reference two workbooks in excel. I
work better with visuals so they are below:

First workbook

Column A Column B Column DB
Acct_Name Acct_# Total Qty
ABC Corp. 54321 (Value to be entered with VLOOKUP)

Second workbook

Column B Column N
Acct_# Total Qty
54321 8

I am trying to retrieve the value in column N of the second workbook for
column DB in the first workbook, based on the exact match of the Acct_#.

I used the following formula in cell DB2: =VLOOKUP(B2,'Second
Workbook.xls'!$B$7,13,FALSE) this is only working on a select few. I can't
figure out why it's not working.

I have formatted the column exactly the same, made sure there were no
leading or trailing spaces, and it still won't work unless I copy and paste
the acct number from the second workbook to the first workbook.

I doesn't make any sense! And it's driving me crazy! Any help would be
GREATLY appreciated.

Leslie