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?

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?