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:
mariana_n23 pe Simpatie
 | Femeie
24 ani
Brasov
cauta Barbat
29 - 52 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 895
|
|
I tried to do a nested XLOOKUP to search in 1 table, and if not found to search in another.
Even though together the tables contained all the looked up values, using it like below showed only a few of them, and #N/A for the rest.
=XLOOKUP(CHOOSECOLS(C3#;6);Table10[Cod mat];Table10[Categorie];
XLOOKUP(CHOOSECOLS(C3#;6);Table4[Cod mat];Table4[Categorie];NA();0;1);
0;1) |
Solution:
=LET(
code; CHOOSECOLS(C3#;6);
IFERROR(
XLOOKUP(code; Table10[Cod mat]; Table10[Categorie];;0);
XLOOKUP(code; Table4[Cod mat]; Table4[Categorie];;0)
)
) |
|
|
| pus acum 1 luna |
|