Forum Discussion

BracePBI's avatar
BracePBI
Frequent Visitor
5 years ago
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)...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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