Replicating vlookup in same table

Hi - apologies if I'm missing something really obvious here, but I'm struggling to replicate a Vlookup in Power BI.

I have a table with 3 columns, the first is a consecutive ID value for each row, the second is a text string, and the third is another set of IDs which reference the first column.  I need to add another column which shows the text string from the second column, where the IDs in the first and third columns match. This is a simple Vlookup in Excel...

This table uses data from a Sharepoint Task app. The third column uses IDs to reference task hierarchy within a list, e.g. a task begins with one entry and then multiple sub-tasks, each referencing the first task. The data from Sharepoint only provides IDs, whereas I need to use the text strings (task names) in my report.

Any help would be much appreciated! Thanks