VLOOKUP not working all the time...

[Guest]

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

 

[Guest]

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

 

[vezerid]

Is there any chance that the codes are numbers in one sheet and text
in the other? You can use ISTEXT(A1) or ISNUMBER(A1) to see if it is
considered as text or numeric.

If you discover that in one of the sheets the numbers are stored as
text, to convert them to numbers click on an empty cell, Edit>Copy,
and then select all textual numbers and Edit>Paste Special...> click
the Add checkbox.

HTH
Kostis Vezerides

 

[Guest]

You are only looking at on cell .....unless your formula was a typo .....

=VLOOKUP(B2,'Second Workbook.xls'!$B$7:$N$100,13,FALSE)

HTH

 

[Guest]

Vezerid,

YOU ARE THE BEST!!! THAT WAS TOTALLY COOL!!

Thank you so much! The corrected the problem 100%!

Thank you, thank you!!!