Sheets, if cell value exist then display a different cell-CodePudding

Home > Net > Sheets, if cell value exist then display a different cell

Sheets, if cell value exist then display a different cell

Time：01-13

What I am trying to do:

Search column "B" for the partial word "treasury", if the cell value in column "B" exist then display the cell in column "E" (same row).

CodePudding user response：

solved: =vlookup("*treasury*",'January (1/22)'!B:E,4,false)

CodePudding user response：

try in E2:

=INDEX(IF(REGEXMATCH(B2:B, "(?i)treasury"), B2:B, ))