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 don't multi-post - you have an answer elsewhere.

Pete

On Jul 12, 5:30 pm, 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

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

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

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.

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

Thank you onece again.

"Tim Shnell" wrote:

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.

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/