FIND VALUE IN COLUMN

samuel · Oct 5, 2006

i can't figure the logic to this statement

IF A2 EXISTS IN K2:K155 THEN "80100" ELSE FALSE

how would i write that in excel?

David Billigmeier · Oct 5, 2006

=IF(COUNTIF(K2:K155,A2)>0,80100)

samuel · Oct 5, 2006

that's it. thanks.

David Billigmeier said:
=IF(COUNTIF(K2:K155,A2)>0,80100)