Drop with Multiple Column Options

An Excel file that teaches how to perform Drop with Multiple Column Options operation.

Excel Solution: Drop with Multiple Column Options

The selection field dynamically determines the target column. INDEX and MATCH are used together. Approximate matching is managed with a separate parameter. Placeholders are assigned to empty results. The report field is kept organized.

Hope it is useful.