Mar 15 2019 11:25 AM
What formula could I use to have excel search a spreadsheet for a specific word and simply return the letter of the column that it appears in?
I have a somewhat complicated spreadsheet set up that looks through data when it is copy/pasted in. However, some data sets have the columns in different order. My arrays/formulas allow me to manually input the column letter into a cell (i.e. "B" or "C" or whatever column it happens to be in) and the array adjusts. However, I feel like Excel should be able to search and tell me the column letter itself.
Any ideas?
Thanks,
Greg
Mar 15 2019 08:05 PM