Mac Forum / Applications / Excel / July 2007

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