Forum Discussion

Freezen's avatar
Freezen
Copper Contributor
Aug 15, 2019
Solved

Excel Combination of IF and VLOOKUP

Hello,   I want to connect the If formula and VLOOKUP formula.   I have a sheet in which not every zip code is present but the Citys are. I'm filling the gaps using a VLOOKUP and a second sheet ...
BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 15, 2019

    Freezen 

    As variant you may generate summary table with Power Query.

    If with formulas you can't replace current value by formula. If only to add one more column where to put current or vlookup-ed value.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 15, 2019

nabilmourad 

Nabil,

Power Query is a great tool, but that always a balance. Refresh is one point. Another one - people usually tend to combine data source, data preparation and reporting in one place, Power Query is more oriented on their separation (as it shall be). Formulas are more universal, in mixed Windows/Mac/mobile/Online environment Power Query is less preferable.

And I guess the main point one shall invest some time to understand how Power Query works and at least basic of M-script. With formulas you may copy/paste the pattern, adjust to your ranges and use it. Not so simple with Power Query if you never used it.

Resources