How to get or return column header based on specific row value in Excel?
In this tutorial, we will search for a specific value in rows of a data range, and then, return the corresponding column header of the matching row cell.
For getting the column header based on specific row value in Excel, the below formula can help you.
1. Select a blank cell to output the header, copy the below formula into it and press the Enter key to get the corresponding header.
Note: In the formula, $C$2:$G$2 is the header range, $C$3:$G$6 is the range contains the specific value in which you will searching for, I3 is the cell contain the criteria value you will match in range $C$3:$G$6, and $C$2 is the first column of range $C$3:$G$6. Please change them to your needs.
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 5 months agoAmazing. This is very helpful,I was wondering if the value matches more than one header, how to get all headers
To post as a guest, your comment is unpublished.· 8 months agoHi. Awesome example. Any thoughts about if there are duplicate values?
To post as a guest, your comment is unpublished.· 1 years agoThank you for this. Very helpful :)