Thread: FIND VALUE IN COLUMN
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
  
Posts: 176
Default FIND VALUE IN COLUMN
=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?
Reply With QuoteReply With Quote