Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
vlookup/ match or other function?? | Excel Worksheet Functions | |||
MATCH function in a VLOOKUP | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions |