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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: deea_printesa
| Femeie 24 ani Dolj cauta Barbat 24 - 48 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
Source
---
=IF(ISERROR(MATCH(B3;C3;0));"NO MATCH";"")
drag down till the end of the columns
_______________________________________
|
|
pus acum 10 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
=IF(ISNA(VLOOKUP(A2;B2:B1000;1;FALSE));"NO MATCH";"MATCH") or =IF(ISNA(VLOOKUP(A2;B2:B1000;1;FALSE));"NO";"YES")
Source:
or
=NOT(ISNA(VLOOKUP(B1;A:A;1;0)))
VLOOKUP returns the value of B1 in the column A, or #N/A if it's not found. ISNA will return TRUE if no value is found, or FALSE if it is, finally NOT negates the result such that it will return TRUE if value is found and FALSE otherwise.
Source:
Modificat de TRaP (acum 5 ani)
|
|
pus acum 6 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
You can also do it with a much simpler formula but no conditions. Just a simple comparison between two ranges (with COUNTIF) - you can use wildcards
And also with ARRAY formula:
The approach might be a bit different.
_______________________________________
|
|
pus acum 4 ani |
|