FIND VALUE IN COLUMN
that's it. thanks.
"David Billigmeier" wrote:
=IF(COUNTIF(K2:K155,A2)0,80100)
--
Regards,
Dave
"samuel" wrote:
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?
|