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

Home > Blockchain > 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

Time：02-09

I can't figure out a function that would automatically copy the first row value if the value on another rows matches 1. I would need the red dates to be automated. Any advice would be very appreciated, thank you!

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

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

Page link：https//www.codepudding.com/Blockchain/293019.html

Prev:Auto Select Checkbox triggered by another checkbox

Next:How to delete columns based on the first two letters of a neighbouring column

Tags：

Links：
CodePudding