Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
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

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
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.

Similar questions
I
Ivan Medvedev2020-03-04 08:06:16
How to make several page layout options depending on the value of a variable? 2Reply
T
ti_zh_vrach2021-04-10 20:32:19
How to check if a value is in a list in VBA? 1Reply
N
nOXXXXX842019-10-04 06:51:49
How to create a site that will be based on Excel with macros stored on a server (ASP?)? 2Reply
L
LebedevStr2017-05-19 20:53:31
How to format (sort) csv for such a template? 1Reply
M
mladshiyy4ilja2017-05-20 15:44:17
Why won't the Excel file open? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question