Is there any Excel function that can copy culumn's (first row's) name if the value matches? - TagMerge
2Is there any Excel function that can copy culumn's (first row's) name if the value matches?Is there any Excel function that can copy culumn's (first row's) name if the value matches?

Is there any Excel function that can copy culumn's (first row's) name if the value matches?

Asked 1 years ago
1
2 answers

You can do it with

=INDIRECT(ADDRESS(1; MATCH(1;E2:ZZ2)+4))

The inner MATCH searched for "1" in the given array (from E2 to ZZ2). The "+4" is there, because you are beginning to search in column E (=5) and MATCH returns the column within your array.

The ADDRESS takes the first row and the column found by MATCH.

The INDIRECT returns the value of the given ADDRESS.

If you copy this formula down the rows, the search array (E2:ZZ2) is automatically adjusted to search the corresponding row.

Source: link

1

=INDEX($E$1:$O$1;1;MATCH(1;E2:O2;0))

Replace semicolon with comma if your Excel version needs it.

enter image description here

If you have, you can also use Xlookup, it's a bit easier.

=XLOOKUP(1;E2:O2;$E$1:$O$1;"not found")

Source: link

Questions related to 'Is there any Excel function that can copy culumn's (first row's) name if the value matches?'

Is there any Excel function that can copy culumn's (first row's) name if the value matches?
Error in `row.names<-.data.frame`(`*tmp*`, value = value) : duplicate 'row.names' are not allowed
how can i return String value from list by it's name value in dart list
Reshape dataframe with first column values as column names and second column values as row values in r
Excel Match function: Lookup of multiple values in multiple lookup arrays not working when there is just one row in the lookup array
Sum and find average of all the value's in a data frame row based upon one of the data frame's column value R
how can I check a column value=NAN for a datetime row value being the first of the month?
PHP: Can a function know if it's being assigned as a value?
Removing the first character in a row *only if it's a number (Google Sheets / Excel)
How can we get file name, sheet name, max rows, and max columns for all Excel files in a folder?
reading Excel in Python with win32com - it's incorrectly reading header as first row of data
A value of type 'xxx?' can't be returned from a function with return type 'xxx' because 'xxx?' is nullable and 'xxx' isn't
How do I get count of duplicated values and join the table to retrieve each value's name?
How can I rescue from Postgresql's COPY command when copying a large CSV file?
I need to iterate through a pandas df and select only specific rows with a specific value in the first column and then select a value from that row
How can I read n rows after string match in each Excel worksheet?
pandas: get column and row name where row has the highest value for every row
The function can't be unconditionally invoked because it can be 'null'. The '!' will have no effect because the receiver can't be null
A value of type 'String?' can't be returned because function has return type of 'Future<String>?'
A value of type 'Future<bool>' can't be returned from the function because it has a return type of 'Future<void>'

Recent Questions on excel

    Programming Languages