218504/hlookup-in-excel-formula

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.

Can someone please help me with this?

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)

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

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

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

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

Hello, yes u can find your birthdate using ...READ MORE

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

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

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

Try this: =SUMPRODUCT(--(Schedule!$B$3:$F$7=A3)) READ MORE

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.