Formula that searches in a row for a cell/column that contains
Solved/Closed
Related:
- Formula that searches in a row for a cell/column that contains
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Position formula in excel ✓ - Excel Forum
- Formulas for 1st and 2nd position in class - Office Software Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 11, 2016 at 05:31 PM
May 11, 2016 at 05:31 PM
Zellie, Good evening.
Suppose:
B2 = 10
C2 = 20
D2 = 30
E2 = 40
F2 = 50
G2 = 60
AND...
A11 --> =IFERROR(INDEX(B2:G2,MATCH(LARGE(B11:G11,1),B11:G11,0)),"")
Now, try to put some number at any cell from B11 to G11
Please, tell us if it worked for you.
I hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
B2 = 10
C2 = 20
D2 = 30
E2 = 40
F2 = 50
G2 = 60
AND...
A11 --> =IFERROR(INDEX(B2:G2,MATCH(LARGE(B11:G11,1),B11:G11,0)),"")
Now, try to put some number at any cell from B11 to G11
Please, tell us if it worked for you.
I hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
May 12, 2016 at 04:47 AM