Search for a value in multiple columns and return value from Column A-CodePudding

Home > Blockchain > Search for a value in multiple columns and return value from Column A

Search for a value in multiple columns and return value from Column A

Time：04-13

Sheet Example:

A	B	C	D	E	F
Jonas	1	6	11	16	21
Joaquin	2	7	12	17	22
William	3	8	13	18	23
Mark	4	9	14	19	24
Stuart	5	10	15	20	25

Search value example:

Expected Return:

Mark

Formula indicated:

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

Prev:How to make a button have different outputs when clicked the second, third, and fourth time with a s

Next:How can I extract data from specific cells on a specific trigger?

Tags：

google-sheets-formula

Related

Links：
CodePudding