Formula is =vlookup(B59845,CLEAR,2,FALSE) only thing that I have specific is
to go to the next array for the lookup...

"Niek Otten" wrote:

What is your formula now and if you use any defined names, what range do they refer to?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tossaire" wrote in message ...
| 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?