Replicate Vlookup between Excel sheets in Power BI

[BracePBI]

Hi All,

I have Excel workbooks as Source with  Sheet1 and Sheet2

we have Sheet1 Cell values derived from Sheet2 cell values using below Vlookup.

=IF(ISERROR(VLOOKUP($B30,sheet2!$B:$Y,F$10,FALSE)), 0,VLOOKUP($B30,sheet2!$B:$Y,F$10,FALSE)/500)

Please let me know how to implement the solution to show up Sheet1 call values in a table in Power BI.


Thank you

[Anonymous · Accepted solution]

Hi @BracePBI ,

You can refer the solution in the following blogs to get it:

#PowerQuery – Replicate doing an Excel VLOOKUP in M

VLOOKUP in Excel and Power Query PBI

If the above ones can't help you get a solution, please share the example data in Sheet1 and Sheet2 (exclude sensitive data) and the final result you want in order to provide you with a suitable solution. Also attach a specific example to illustrate the calculation logic.

Best Regards

[Greg_Deckler]

@BracePBI You would use LOOKUPVALUE or MAXX(FILTER(...)...) Sample data and expected output always help. Hard to be more specific otherwise.