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:
ro_xy20 pe Simpatie
 | Femeie
24 ani
Bucuresti
cauta Barbat
24 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 892
|
|
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 2 saptamani |
|