Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values for LOOKUP? Maybe add IF clause?
I don't know how to get Column C in the example below into another worksheet
that is searched for BOTH Column A and Column B. Column A = Name Column B = Unit Column C = Value 1 Column D = Value 2 For example, a person (A) works in multiple units (B). I want to move (C) when (A) and (B) match. I need something like IF A = Susan Smith AND B = Unit 123, then vlookup C to cell A5 in Worksheet 2. Does that make sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple values for LOOKUP? Maybe add IF clause?
=SUMPRODUCT(--(A1:A100="Susan Smith"),--(B1:B100="Unit 123"),C1:C100)
you can not use a whole column prior to XL-2007 "DataBeth" wrote: I don't know how to get Column C in the example below into another worksheet that is searched for BOTH Column A and Column B. Column A = Name Column B = Unit Column C = Value 1 Column D = Value 2 For example, a person (A) works in multiple units (B). I want to move (C) when (A) and (B) match. I need something like IF A = Susan Smith AND B = Unit 123, then vlookup C to cell A5 in Worksheet 2. Does that make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Multiple Values | Excel Worksheet Functions | |||
Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
LOOKUP MULTIPLE VALUES | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
how do I lookup multiple values | Excel Discussion (Misc queries) |