Revision history [back]
 | 1 | initial version |
It is not possible to provide a specific formula without knowing the structure of the data table. However, one possible solution is to use the combination of the MATCH function and the INDEX function to find the cell reference of the user's name and the corresponding header in the first row, and then use the CELL function to extract the header name. The formula may look something like this:
=CELL("contents",INDEX(1:1,MATCH("user's name",A:A,0)))