Two Column Look Up the return value

[AliaNi]

I am trying to find a formula which looks up the day first (Row two) and then looks up the metric row (Row three) and then retur the average of that column for me.

I tried installing Xl2bb but it won't work on my computer.

How do you do that? I ran out of all ideas.

 

[awoohaw]

Also, if you are familiar with tables and table structure, or even named ranges it may make this easier.

 

[AliaNi]

You still have the space after Sunday in cell A11

THANK YOU SO SO MUCH.

 

[awoohaw]

You're welcome.

And if a post here has provided you with an answer, please mark it with the "answer" icon.

 

[AliaNi]

You still have the space after Sunday in cell A11

thank youuuu thank youuu!!

 

[awoohaw]

thank youuuu thank youuu!!

you are very very very welcome!