How to get true/false in one or two colum

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
In D1 enter =A1=C1

Copy down by double-clicking the fill handle of C1


Gord Dibben MS Excel MVP
 
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.
 
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.
Click to expand...

=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.
 
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
Click to expand...

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