Forum Discussion
Replicate Vlookup between Excel sheets in Power BI
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
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
2 Replies
- Greg_Deckler
Community Champion
BracePBI You would use LOOKUPVALUE or MAXX(FILTER(...)...) Sample data and expected output always help. Hard to be more specific otherwise.
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
