R
Rapunzel
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
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