Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
Andreea Miluta 24 ani

Femeie
24 ani
Braila
cauta Barbat
30 - 48 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Search String in Cell and Display Value if Found

TRaP · 2024-04-09T10:32:16Z

=IFERROR(IFS(ISNUMBER(SEARCH("aaaa";[@ ]));"aaaa found";ISNUMBER(SEARCH("bbbb";[@ ]));"bbbb found");"CCCC") Source: https://support.microsoft.com/en-us/office/check-if-a-cell-contains-text-case-insensitive-7bb505c7-2815-4a7a-9544-57a5f0dcd551.

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

=IFERROR(IFS(ISNUMBER(SEARCH("aaaa";[@[Desc]]));"aaaa found";ISNUMBER(SEARCH("bbbb";[@[Desc]]));"bbbb found");"CCCC")

Source:
https://support.microsoft.com/en-us/off ... a5f0dcd551

Pagini: 1

Mergi la