Forum Discussion
Searching column headers instead of column letters
I have developed a formula that searches inside an identified column letter (AB or F) for information. Sometimes my coworkers add or remove columns from the spreadsheet which causes the formula not t...
Hi austin93,
You could use the Name Manager to define a name for the columns you are using your formula.
Step 1: Define a name for the column you wish to use in your formula.
Step 2: Use the name defined instead of the column reference in your formula.