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" wrote:

Try this

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

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


"Dingerz" wrote:

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?