They both came back true on the first sheet, after specifying that the second
cell was on the 2nd sheet.

"daddylonglegs" wrote:

Assuming defined range clear is correctly defined then most common cause of
what you describe is data mismatch. If B59856 is a numeric value, not text,
then the lookup range should be too.Test with

=ISNUMBER(B59856) and

=ISNUMBER(X288)

where X288 is the cell that should match B59856, do you get TRUE for both?

"Tossaire" wrote:

have been using Vlookup to reference a 2nd sheet to verify cashed checks
based on the check number on the first sheet. using
=VLOOKUP(B59856,CLEAR,2,FALSE)
which has been working fine. the spreadsheet breaks 40k lines and is excell
2000 so just to be sure it wasn't a memory problem or anything like that I
split it for a new spread and it's under 8k lines for the formula. for some
reason the formula comes up with n/a's for results even though there are
exact matched on the other sheet...ideas?