Forum Discussion
Solved
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)...
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
Community Champion
Community ChampionBracePBI You would use LOOKUPVALUE or MAXX(FILTER(...)...) Sample data and expected output always help. Hard to be more specific otherwise.