Vlookup/Match Function
 

Hello all, hope you can help!

Here is my dilema. i have a raw data that is formatted like this

group type value1 value2

group a new 1 1
group a old 1 1
group b new 1 1
group b old 1 1

I need to be able to pull data horizontally on another datasheet first by
type and then by group. Format looks like this:

Value1 for new Value2 for new Value1 for
old Value2 old
group name

I have no clue where to start. I have done vlookups and matches before, but
not for multiple columns. Thought of using an If statement with an and, but
can't conceptualize how it would look.

Please help!

Vlookup/Match Function
 

group type Value1 value2 <==Row 1
group a new 1 2
group a old 3 4
group b new 5 6
group b old 7 8

Results:

Group Value 1 Value 2 Value 1 value2 '<=== row 8
Group a 1 2 3 4
Group b 5 6 7 8

new Value 1 (B9)

=SUMPRODUCT(--($A$2:$A$5=$A8),--($B$2:$B$5="new"),$C$2:$C$5)

new Value 2 (C9)

=SUMPRODUCT(--($A$2:$A$5=$A8),--($B$2:$B$5="new"),$C$2:$C$5)

Copy above to D9 & E9

Replace "new" with "old" for Old values 1 & 2

Copy B9:E9 down

HTH

"PiB311" wrote:

Hello all, hope you can help!

Here is my dilema. i have a raw data that is formatted like this

group type value1 value2

group a new 1 1
group a old 1 1
group b new 1 1
group b old 1 1

I need to be able to pull data horizontally on another datasheet first by
type and then by group. Format looks like this:

Value1 for new Value2 for new Value1 for
old Value2 old
group name

I have no clue where to start. I have done vlookups and matches before, but
not for multiple columns. Thought of using an If statement with an and, but
can't conceptualize how it would look.

Please help!