COmparing a cell with a colum of data

D

Dingerz

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
 
H

HelpExcel.com

You need to enter a formula for each line to receive a Yay/Nay response for
each.
The way you've entered it is indicative of a formulaic array, however, you
would need to encapsulate it further for the data to make sense.
 
H

HelpExcel.com

You need to enter a formula for each line to receive a Yay/Nay response for
each.
The way you've entered it is indicative of a formulaic array, however, you
would need to encapsulate it further for the data to make sense.
 
J

Jacob Skaria

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
 
J

Jacob Skaria

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
 
D

Dingerz

Can you please show me what formula i must use.

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.





HelpExcel.com said:
You need to enter a formula for each line to receive a Yay/Nay response for
each.
The way you've entered it is indicative of a formulaic array, however, you
would need to encapsulate it further for the data to make sense.
--
Regards,
Eddie
http://www.HelpExcel.com


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
 
D

Dingerz

Can you please show me what formula i must use.

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.





HelpExcel.com said:
You need to enter a formula for each line to receive a Yay/Nay response for
each.
The way you've entered it is indicative of a formulaic array, however, you
would need to encapsulate it further for the data to make sense.
--
Regards,
Eddie
http://www.HelpExcel.com


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
 
D

Dingerz

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
 
D

Dingerz

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
 
J

Jacob Skaria

For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jacob Skaria

For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
D

Dingerz

Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
D

Dingerz

Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





Jacob Skaria said:
Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jacob Skaria

Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jacob Skaria

Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
D

Dingerz

Thanks jacob,

If i can tdo that is it possible to make it tell me the contents of the cell
next to it.

For example:

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",******CELL CONTENTS OF B.XXX.***)

Where B.XXX. is row B and the column where a match was found

Jacob Skaria said:
Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


:

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
D

Dingerz

Thanks jacob,

If i can tdo that is it possible to make it tell me the contents of the cell
next to it.

For example:

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",******CELL CONTENTS OF B.XXX.***)

Where B.XXX. is row B and the column where a match was found

Jacob Skaria said:
Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

Jacob Skaria said:
For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


:

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jacob Skaria

To returrn value from B for a match in A try this

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",INDEX(B1:B15,MATCH(I9,A1:A15,0)))

Alternatively you may use the VLOOKUP function

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks jacob,

If i can tdo that is it possible to make it tell me the contents of the cell
next to it.

For example:

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",******CELL CONTENTS OF B.XXX.***)

Where B.XXX. is row B and the column where a match was found

Jacob Skaria said:
Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

:

For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


:

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jacob Skaria

To returrn value from B for a match in A try this

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",INDEX(B1:B15,MATCH(I9,A1:A15,0)))

Alternatively you may use the VLOOKUP function

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks jacob,

If i can tdo that is it possible to make it tell me the contents of the cell
next to it.

For example:

=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA",******CELL CONTENTS OF B.XXX.***)

Where B.XXX. is row B and the column where a match was found

Jacob Skaria said:
Using a formula you can get the number of instances; but to return the cell
references as a comma separated text you will have to use a UserDefined
Function.

If this post helps click Yes
---------------
Jacob Skaria


Dingerz said:
Thanks Jacob any ideas on the frist part?

:

For the second query use absolute reference like below

=IF(ISERROR(MATCH(I7,$A$1:$A$15,0)),"NA","YAY")

--
If this post helps click Yes
---------------
Jacob Skaria


:

Thanks Jacob that was helpful. Can you help me further....

As well as saying Yay or Nay how do i make the cell tell me which cells a
match was found in. Eg: Yay, L1,L2,L6


Also when i drag down a series of formulas using the crosshair that appears
in the botoom right hand corner of the cell it changes the formula. For
example,

=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A2:A16,0)),"NA","YAY")

I want only one column to increment by this i mean:
=IF(ISERROR(MATCH(I7,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I8,A1:A15,0)),"NA","YAY")
=IF(ISERROR(MATCH(I9,A1:A15,0)),"NA","YAY")

How do i do this without having to type the formula in over and over again.


Thanks for your hlp





:

Try this

=IF(ISERROR(MATCH(K12,L1:L15,0)),"NA","YAY")

If this post helps click Yes
---------------
Jacob Skaria


:

Hi iam having trouble wiht my formula

=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc
Upload'!$A:$A,"New","Old")


or even

=IF(K12=L1:L15,"YAY","NA")

It will only check if the data is on the same row. I want excel to compare
one particular cell with all the cells in a whole entrie column for a match
and then tell me yes or no.

How do i do this?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing colum data and exporting 3
comparing formula results with a cell 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Comparing Data Across Cell Ranges 2
Calculation if a cell contains a word 4
How do I Go To a cell based on input in another cell? 3
Stuck on a Formula 2
check first 3 characters of a cell and compare to a table 4

Top