Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
I would like to know if there is a way to do the following:
File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
Is Red/12 in a *single* cell?
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" <ABC Seamless wrote in message ... I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
Yes it is. I had them in three cells then converted them to two, so they can
be either. "RagDyer" wrote: Is Red/12 in a *single* cell? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" <ABC Seamless wrote in message ... I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
It's easier if you they're each in their own column, so go back to using 3.
On Sheet1, With color in A2 to A25, Size in B2 to B25, And count in C2 to C25 On Sheet2, Size in A2 to A4, And color starting in B1, and going out along Row 1 to T1 (19 colors). Try this in B2: =SUMPRODUCT((Sheet4!$A$2:$A$25=B$1)* (Sheet4!$B$2:$B$25=$A2)*Sheet4!$C$2:$C$25) And copy down to B4, Then copy across to T1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" wrote in message ... Yes it is. I had them in three cells then converted them to two, so they can be either. "RagDyer" wrote: Is Red/12 in a *single* cell? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" <ABC Seamless wrote in message ... I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
THANK YOU!!! It is working Great!!
"RagDyer" wrote: It's easier if you they're each in their own column, so go back to using 3. On Sheet1, With color in A2 to A25, Size in B2 to B25, And count in C2 to C25 On Sheet2, Size in A2 to A4, And color starting in B1, and going out along Row 1 to T1 (19 colors). Try this in B2: =SUMPRODUCT((Sheet4!$A$2:$A$25=B$1)* (Sheet4!$B$2:$B$25=$A2)*Sheet4!$C$2:$C$25) And copy down to B4, Then copy across to T1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" wrote in message ... Yes it is. I had them in three cells then converted them to two, so they can be either. "RagDyer" wrote: Is Red/12 in a *single* cell? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" <ABC Seamless wrote in message ... I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP or IF??
I apologize for not matching the sheet references in my formula to the sheet
references in my scenario. You're welcome, and thanks for the feed-back. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "ABC Seamless Wayne" wrote in message ... THANK YOU!!! It is working Great!! "RagDyer" wrote: It's easier if you they're each in their own column, so go back to using 3. On Sheet1, With color in A2 to A25, Size in B2 to B25, And count in C2 to C25 On Sheet2, Size in A2 to A4, And color starting in B1, and going out along Row 1 to T1 (19 colors). Try this in B2: =SUMPRODUCT((Sheet4!$A$2:$A$25=B$1)* (Sheet4!$B$2:$B$25=$A2)*Sheet4!$C$2:$C$25) And copy down to B4, Then copy across to T1. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" wrote in message ... Yes it is. I had them in three cells then converted them to two, so they can be either. "RagDyer" wrote: Is Red/12 in a *single* cell? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ABC Seamless Wayne" <ABC Seamless wrote in message ... I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2 Size Red Blue Green.... 12 24 36 I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19 colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in the File #2 with amounts. Any Help Please??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |