Forum Discussion
Excel Combination of IF and VLOOKUP
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.
I hear you Sergei, The issue also is: for each City we may have multiple Zip codes while each Zip code corresponds to one city.It wasn't clear to me weather the lookup value for Freezen will be the City or the Zip Code, that's why I asked for a sample. I was considering a helper column as well.
On the other hand, I have a preference to the Power Query option but I always noticed (in my courses) that clients are fearful from PQ and have a tendency to Formulas... I don't know why? is it because formulas update without Refresh? may be!
Have a great day everyone.
Nabil Mourad
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.
I agree my friend