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
Recent Questions...
ما را در سایت Recent Questions دنبال می کنید
برچسب : excel vlookup find string, نویسنده : استخدام کار superuser بازدید : 493 تاريخ : جمعه 12 شهريور 1395 ساعت: 18:30