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.
Hi
Yes of course you can but instead of reinventing the sheet, would you please share either a sample Excel data or a snap shot with column Letters & Row Numbers to facilitate customizing the formula for your situation.
Good Luck
Nabil Mourad
My Excel is in German; SVERWEIS is VLOOKUP; PLZ stands for ZIP Code; WENN is IF
