Forum Discussion
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 ...
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.
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.
- That would challenge my ongoing process, I'm using the Excel sheet later in combination with a Word text to generate series letters which I post as ads in job portal. I don't think I can fill in the postal code from two cell sources
With mail merge you may ignore your current PLZ column and use added one, let say PLZfilled, into which you add the post code from PLZ if not empty, otherwise the value returned by VLOOKUP.
