Lookup table inconsistancies

[amy_walker]

Hi,

I have made a table on one worksheet page, and a set up a lookup
function on another page in the same workbook. Here is my formula
=LOOKUP(C2,'Whole Genome Lib'!A:A,'Whole Genome Lib'!C:C). The lookup
function works great for a while, but at a particular point in the
table, the formula no longer returns the correct values. I had
thought that the problem may be in my table (very large, with
references to multiple different workbooks), so I copied and repasted
as values only. Also, the reference vaules that I am looking up may
be a problem, as they are a mix of letters and numbers (ie, V-6D03).
I have tried setting these to general format and text format as well.

Thanks for any advice!

Amy Walker

 

[Bob Greenblatt]

Hi,

I have made a table on one worksheet page, and a set up a lookup
function on another page in the same workbook. Here is my formula
=LOOKUP(C2,'Whole Genome Lib'!A:A,'Whole Genome Lib'!C:C). The lookup
function works great for a while, but at a particular point in the
table, the formula no longer returns the correct values. I had
thought that the problem may be in my table (very large, with
references to multiple different workbooks), so I copied and repasted
as values only. Also, the reference vaules that I am looking up may
be a problem, as they are a mix of letters and numbers (ie, V-6D03).
I have tried setting these to general format and text format as well.

Thanks for any advice!

Amy Walker

How large is large? What point in the table does it stop working? Are all
subsequent lookups wrong, or only a few? Have you sorted column A? The
lookup array MUST be in descending order.

 

[amy_walker]

How large is large? What point in the table does it stop working? Are all
subsequent lookups wrong, or only a few? Have you sorted column A? The
lookup array MUST be in descending order.

There are 16410 rows in my table (columns A-I).

I set the format to text in both my table and lookup page and resorted
-- now its working.

Thanks,
Amy