Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More lookup help
I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll
try to explain. Sheet 1 needs to look up the name of a person that is in both sheets. Sheet2 contains all the infomration and the name appears more than once. I want the cell too automatically look up the name. After that it needs to look up for the number of "yes" values that are in sheet 2 clumn D linked to the name on sheet 1 column B I've tried so many different things but not sure how it should be Hope this makes sense |
#2
|
|||
|
|||
Try using the VLOOKUP function.
"Jaco Jacobs" wrote: I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll try to explain. Sheet 1 needs to look up the name of a person that is in both sheets. Sheet2 contains all the infomration and the name appears more than once. I want the cell too automatically look up the name. After that it needs to look up for the number of "yes" values that are in sheet 2 clumn D linked to the name on sheet 1 column B I've tried so many different things but not sure how it should be Hope this makes sense |
#3
|
|||
|
|||
Assuming the names are listed in col. C in Sheet2:
=SUMPRODUCT((Sheet2!$C$1:$C$20=B1)*(Sheet2! $D$1:$D$20="yes")) HTH Jason Atlanta, GA -----Original Message----- I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll try to explain. Sheet 1 needs to look up the name of a person that is in both sheets. Sheet2 contains all the infomration and the name appears more than once. I want the cell too automatically look up the name. After that it needs to look up for the number of "yes" values that are in sheet 2 clumn D linked to the name on sheet 1 column B I've tried so many different things but not sure how it should be Hope this makes sense . |
#4
|
|||
|
|||
On sheet2 the names are in column C
"Jason Morin" wrote: Assuming the names are listed in col. C in Sheet2: =SUMPRODUCT((Sheet2!$C$1:$C$20=B1)*(Sheet2! $D$1:$D$20="yes")) HTH Jason Atlanta, GA -----Original Message----- I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll try to explain. Sheet 1 needs to look up the name of a person that is in both sheets. Sheet2 contains all the infomration and the name appears more than once. I want the cell too automatically look up the name. After that it needs to look up for the number of "yes" values that are in sheet 2 clumn D linked to the name on sheet 1 column B I've tried so many different things but not sure how it should be Hope this makes sense . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup using more than one Lookup value | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |