Conditional Vlookup, or may be some other formula

[Hrishi]

Hello, I have 2 tables with me. TABLE A has 3 columns, column 1 has document number which is unique number, this document may have multiple revisions, with different amount which I will keep adding in future as well. This amount is budget for me.

Doc number	Revision number	Amount
RF01	0	10
RF01	1	15
RF02	0	50
RF02	1	100
RF02	2	150
RF01	2	500
RF03	0	300

<tbody>
</tbody>

Now there is another table TABLE B where I want this data to be imported.

Doc Number	Budget (This value should be of latest revision.)
RF01	500
RF03	300
RF02	150
RF01	500

<tbody>
</tbody>

Now as the document numbers will keep on addition in table A as well as Table B, I want formula in Budget column of table B that look for concern document number in first column, then it will check latest revision available and accordingly fetch the respective budget from Table A to Table B.

 

[sandy666]

I read all descriptions twice
Honestly I don't know what do you want from me?
there are formulas - I don't work with formulas I changed only your IFS to =--CHOOSE(MATCH(LEN(C6),{2,3},0),RIGHT(C6,1),RIGHT(C6,2)) to be compatible with older version of Excel
I can't see the result (what do you want to achieve)

so due to above - I can't help
PowerQuery works with columns and content (data) not with calculated formulas. formula doesn't exist for PQ - result of formula - exist