Thread
:
LOOKUP or IF??
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
external usenet poster
Posts: 3,572
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???
Reply With Quote
RagDyeR
View Public Profile
Find all posts by RagDyeR