Thread: COmparing a cell with a colum of data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dingerz Dingerz is offline
external usenet poster
  
Posts: 16
Default COmparing a cell with a colum of data
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?
Reply With QuoteReply With Quote