Reference - Vlookup

  • Thread starter Vanessa Simmonds
  • Start date
V

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top