Say I have a file that looks somthing like this
Where Dog,Cat, Bird, Fish and Tiger represent the Data in Row 1 (the column headings) and the x's represent the other rows of data. How can I write a formula to search Row 1 for "FISH" and return "D" since FISH is the fourth column and thus in excel would be in column D.Please Login or Register to view this content.
Bookmarks