# 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
- Number to words in excel formula - Guide
- Saints row 2 cheats - Guide
- Position formula in excel - Office Software 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

May 12, 2016 at 04:47 AM