You can enable the macros in a certain Excel file for an individual time, without turning that Excel workbook right into a reliable document, by following the method I make clear down below. By default, the value while in the heading is just not A part of the sort Procedure. https://www.customguide.com/excel/hlookup