Vertical Gap

An Excel file that teaches how to perform Vertical Gap operation.

Excel Vertical Gap

The two columns are turned into a concatenated key. The same logic is applied on the search side. VLOOKUP is operated via a combo key. An alternative scenario is added for values ​​that cannot be found. The solution template is left available for reuse.

Hope it is useful.