خرید بک لینک

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, نویسنده: استخدام کار تاريخ: جمعه 12 شهريور 1395 ساعت: 18:30

صفحه بندی