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...
Hello Austin,
In Sheet2!C2 of the attached file, I modified the formula to this:
=SUMPRODUCT(--ISNUMBER(SEARCH(B2,Sheet1!A:A)))
I see no error in the results in Sheet2 although you insert a column in Column B of Sheet1 because the relative references will automatically adjust to return the correct results.