Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference - Vlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference - Vlookup
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 "Vanessa Simmonds" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
invalid reference for vlookup | Excel Worksheet Functions | |||
Vlookup reference the row below | Excel Worksheet Functions | |||
Vlookup reference a worksheet | Excel Worksheet Functions | |||
VLOOKUP Reference Help | Excel Discussion (Misc queries) | |||
Vlookup reference a worksheet | Excel Worksheet Functions |