I want to get with my ID the matching string, I am trying to accomplish that with a VLOOKUP
=VLOOKUP(L2;Tree_Matchingnode!A:B;1;0)
The Table that I am doing the Vlookup looks like this:
+----------------+------------------+
| Parent_TREE_ID | Parent_TREE_NAME |
+----------------+------------------+
| 1 | |
| 2 | |
| 3 | |
+----------------+------------------+
The Matching tabel looks like this:
+-------------+----+
| Folder_PATH | ID |
+-------------+----+
| Path1 | 1 |
| Path3 | 9 |
| Path15 | 3 |
+-------------+----+
My result should be that the the ID's from the first table match the correct path coming from the second table
برچسب: excel vlookup find string,
نویسنده: استخدام کار