lookup in values within same table

[krrishkrsna]

hi

sorry if Title given in confusing way

in my data having columns of InvNum,MaterialNum,MaterialName,MaterialName1
[TABLE="width: 282"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]InvNum[/TD]
[TD]Material[/TD]
[TD]MaterialName[/TD]
[TD]MaterialName1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AB[/TD]
[TD]ABC[/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]KL[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]MN[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]ABL[/TD]
[TD]DEF[/TD]
[TD]DEF[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]GH[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]IJ[/TD]
[TD]GHI[/TD]
[TD]GHI[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]OP[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BC[/TD]
[TD]MNO[/TD]
[TD]MNO[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]DE[/TD]
[TD]JKL[/TD]
[TD]JKL[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]IJL[/TD]
[TD][/TD]
[TD]GHI[/TD]
[/TR]
</tbody>[/TABLE]


1. will do vlookup on Material to get result of MaterialName (ie.,vlookup(material,anothertable,2,0))
2. will do vlookup for materialname1 within the same table to get result of MaterialName1 (ie., vlookup(invoicenum,invoicenum:materialname,3,0))

i think above cleared the doubt to providing your answer

i need formula to achieve above result in PowerQuery for MaterialName1