Formula help

[swellybro]

Hello,

I am hoping some excel whizz can help me....

I would like to set up a look up to search a spreadsheet containing data like this....I was able to write vb code that looped through the data but I don’t know how to do this with a formula.

I need to be able to search for a raw score (the one in column A) e.g. 2
but also cross-reference the header row for an age in months and years so for example 8.10

which would return the score 74.

What would the formula be?

Thank you,

 

[Toadstool]

Hi Swellybro,

So it's looking for the intersection? Does this work for you?

Swellybro.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Score	8.04	8.05	8.06	8.07	8.08	8.09	8.10	8.11	9.00	9.01	9.02	9.03		Score	2
2	0	69	69	69	69	69	69	69	69	69	69	69	69		Age	8.10
3	1	71	71	71	70	70	69	69	69	69	69	69	0		Result	74
4	2	76	76	75	75	75	74	74	73	73	72	72	71
5	3	79	79	78	78	77	77	77	76	76	75	75	74
Sheet1

Cell Formulas
Range	Formula
P3	P3	=INDEX($B$2:$M$5,MATCH($P$1,$A$2:$A$5,0),MATCH($P$2,$B$1:$M$1,0))

 

[swellybro]

That works perfectly thank you ?

 

[Toadstool]

You're welcome.
Thanks for letting me know.