how to find particular text on cell

[krunal123]

EX: A1 cell EXP/089/20-21


# i try to find particular word to alert condition

# find : /20-21 (this word fount to alert to other cell , "ok","Not"

 

[sandy666]

with Power Query
an example

Source	Search		Source	Search	YN
EXP/089/20-21	/20-21		EXP/089/20-21	/20-21	Ok
EXP/089/20-22	/20-21		EXP/089/20-22	/20-21	Nor

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    IF = Table.AddColumn(Source, "YN", each if Text.Contains([Source], [Search]) then "Ok" else "Nor")
in
    IF

 

[Michael M]

Try using

=IF(ISNUMBER(SEARCH("/20-21",A1)),"OK","NOT")

 

[sandy666]

or this way

Table1		Table2		Result
Source		Search		Source	YN
EXP/089/20-21		/20-21		EXP/089/20-21	Ok
EXP/089/20-22				EXP/089/20-22	Nor

let
    Search = Excel.CurrentWorkbook(){[Name="Table2"]}[Content][Search]{0},
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    IF = Table.AddColumn(Source, "YN", each if Text.Contains([Source], Search) then "Ok" else "Nor")
in
    IF

 

[krunal123]

Thanks

 

[sandy666]

You are welcome

 

[Michael M]

@krunal123
Which method did you use ??

 

[DanteAmor]

Here are a couple of options to consider.

varios 19sep2020.xlsm
	A	B
1	EXP/089/20-21	Ok
2	EXP/089/20-22	Not
3
4	EXP/089/20-21	Ok
5	EXP/089/20-22	Not
Hoja2

Cell Formulas
Range	Formula
B1:B2	B1	=IF(RIGHT(A1,6)="/20-21","Ok","Not")
B4:B5	B4	=IF(ISERR(FIND("/20-21",A4)),"Not","Ok")