Thread: LOOKUP or IF??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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???