ExcelBanter - FIND VALUE IN COLUMN

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - FIND VALUE IN COLUMN (https://www.excelbanter.com/excel-worksheet-functions/113044-find-value-column.html)

Samuel

FIND VALUE IN COLUMN

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

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?

Samuel

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?

All times are GMT +1. The time now is 04:37 PM.