D
DataBeth
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?
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?