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:
Profil Lolo
 | Femeie
24 ani
Galati
cauta Barbat
25 - 52 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 961
|
|
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)
)
) |
|
|
| |
|
