Look up two rows then return the metric for that selection.

[AliaNi]

Please see the attached table.

I am trying to write a formula which will look up the day first then look up the metric based on the table below.

The expected results are provided. For example: the crossing of metric 1 and Sunday should yield 49. (The median for the whole column)

I hope I was able to explain what I wanted. Any help is greatly appreciated.

Book1
	A	B	C	D	E	F	G
1		Sunday			Monday
2	ID	Metric 1	Metric 2	Metric 3	Metric 1	Metric 2	Metric 3
3	2	33	54	55	23	75	84
4	3	23	33	33	33	98	72
5	4	65	22	88	44	65	77
6	1	92	11	33	55	33	56
7
8	expected results	49	27.5	44	38.5	70	74.5
9
10		Metric 1	Metric 2	Metric 3
11	Sunday
12	Monday
Sheet1

Cell Formulas
Range	Formula
B8:G8	B8	=MEDIAN(B3:B6)

 

[Fluff]

Duplicate to: Two Column Look Up the return value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.