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!
|