Good Morning,

Is it possible on excel to build a formula that will look for a reference in
a row and once it is found look for a second reference on the column and
return the cell value?

For example

A B C D
1 Reference Week 1 Week 2 Week 3
2 Vanessa 45 45 32
3 David 54 78 87
4 Cameron 65 34 56
5 Lianne 76 50 58
6 Marcelo 78 21 54

I need a formula that would for example look for Cameron and look for Column
Week 3 and return value 56.

Is it possible?

Best Regards,

Vanessa Simmonds