On Jul 12, 11:16 am, Qazi Ahmad
wrote:
It not help me because i have Bank cheque no in Colum A1 to A500 wich i
issued to custumers and in B1 to B1000 which show cheque no which draw from
bank. now i want to findout which chque is draw from bank. cheque no are not
in same raw. numbers are in different row i just want to findout the same
chequ number in bothe colum.
thanks.

"Gord Dibben" wrote:
In D1 enter =A1=C1

Copy down by double-clicking the fill handle of C1

Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 09:30:03 -0700, Qazi Ahmad
wrote:

How I can display True/Fale in a one or two colum, if colum A1 to A500 and
C1 to C5000 have same amount. With a formula or Micro

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,0)),"Not Found","Found")

Put in C1 and copy down to C500. This will return "Found" if the
cheque no in column A is also listed in column B.