Excel Vlookup find matching string

ساخت وبلاگ

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