Reference - Vlookup

[Vanessa Simmonds]

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

 

[Mike H]

Hi,

try this

=SUMPRODUCT((B2:B6="Cameron")*(C1:E1="Week 3")*(C2:E6))

In practice I'd use cell references for the lookup values
=SUMPRODUCT((B2:B6=F1)*(C1:E1=F2)*(C2:E6))

Mike