How to get true/false in one or two colum

[Guest]

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

 

[Pete_UK]

Please don't multi-post - you have an answer elsewhere.

Pete

 

[Gord Dibben]

In D1 enter =A1=C1

Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP

 

[Guest]

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.

 

[Tim Shnell]

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.

=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.

 

[Stan Brown]

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

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

Please read responses in the other newsgroup where you posted this,
and in the future please don't post duplicate articles.

 

[Guest]

Thank you, it help me to over come my problem.

Thank you onece again.