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?