D
D
Djasar2021-04-01 10:30:49
excel
Djasar, 2021-04-01 10:30:49

What function or formula should I use?

There is a table with products in which values ​​are not repeated.
You need to find the product to which product it belongs.
THOSE. if I enter values ​​into the list, then it gives me which product it belongs to.
6065768b713e0429529763.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Djasar, 2021-04-01
@Djasar

=INDEX(A$1:E$1;;SUMPRODUCT((A13=A$2:E$7)*COLUMN(A:E)))
Thanks Man from another forum.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question