match and index newbie

[avk_curr]

Hi All,

Probably a simple question, but I need to use a match and index, but I've never used them before.

I need to look up the years and then look up the month and provide a value
For example
1 year and 5 months would produce 1.1556

Years	Monnth
	0	1	3	4	5	6
0	0	.0722	.1444	.2167	.2889	.3611
1	.8667	.9389	1.00111	1.0834	1.1556	1.2278
2
3
4
5
6

<tbody>
</tbody>

 

[JoeMo]

The first MATCH returns the row number. The second MATCH, the column number.
Domain

	A	B	C	D	E	F	G	H	I	J
1	Years	Monnth							Year	1
2		0	1	3	4	5	6		Month	5
3	0	0	0.072	0.1444	0.217	0.289	0.361		Value	1.1556
4	1	0.8667	0.939	1.0011	1.083	1.156	1.228

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:40px;"><col style="width:56px;"><col style="width:46px;"><col style="width:53px;"><col style="width:46px;"><col style="width:46px;"><col style="width:46px;"><col style="width:22px;"><col style="width:48px;"><col style="width:49px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula J3 =INDEX($A$2:$G$4,MATCH(J1,A2:A4,0),MATCH(J2,A2:G2,0)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[markmzz]

Hi!

You can try this too (with JoeMo's layout):

=VLOOKUP(J1,$A$3:$G$9,MATCH(J2,$A$2:$G$2,0),0)

or

=HLOOKUP(J2,$B$2:$G$9,MATCH(J1,$A$2:$A$9,0),0)

Markmzz

 

[avk_curr]

Thank you, I think I was missing the MATCH(J1,A2:A4,0),MATCH(J2,A2:G2,0)) I was referencing the whole table A2:G4 each time,
Need to learn match and index better

 

[avk_curr]

interesting. Thanks

 

[AhoyNC]

Here is a link on using INDEX / MATCH.

https://www.youtube.com/watch?v=u-8D2G0y9EM

 

[markmzz]

interesting. Thanks

You are welcome.

Markmzz