This is my excel file:

In this Excel document, cell J2 needs to contain a formula that does the following: In the filled matrix, it would search for the letter C (column), and then it would give me the value. For instance, if J2 had the number 43,24 as its first value, I would drag the formula all the way to the end (the 14th row, where the matrix's filled values are fixed \$\$).

The Final output should be like this:

My problem is that I can't fix the filled matrix (\$\$) in my HLOOKUP/VLOOKUP.

Dec 17, 2022 in Others 464 views

## 1 answer to this question.

If you want to switch up the C and F, you need one INDEX with a MATCH for the row and a MATCH for the column, like this:

```=INDEX(\$B\$2:\$G\$14,MATCH(\$I2,\$A\$2:\$A\$14,0),MATCH(J\$1,\$B\$1:\$G\$1,0))
```

If you don't need to do a match on the date, then simply remove that part of the formula:

```=INDEX(\$B\$2:\$G\$14,,MATCH(J\$1,\$B\$1:\$G\$1,0))
```

Or if you want to use HLOOKUP, then like this:

```=HLOOKUP(J\$1,\$B\$1:\$G\$14,ROW(),TRUE)
```

• 63,720 points

## Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

## How to get sum of all matches of HLOOKUP in Excel?

Consider: =SUMPRODUCT((A1:E1="apple")*(A2:E2)) To include more ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE