vlookup
Alright, im a little lost. Whats this value that you are talking about? Is it
the quantity?
"luckyie" wrote:
ok tks.
on sheet 1, I have all the information
column A: fruit names
column B: quantity
colunm C: origin
column D: category
on sheet 2, I have a resume where I will put:
cell B2: I enter the fruit name
cell B3: I enter the origin
cell B4: I enter the category
In cell D3 , I would like to have the value according to criteria in cell
B2+B3+B4.
Is it possible?
--
lucky
"akphidelt" wrote:
SUMPRODUCT
Or if you gave a little example it would be easier to explain
"luckyie" wrote:
Hi everyone,
I am trying to creata a formula that will return a value depending on 3
criteria. With Vlookup I could only find the formula retrieving a value based
on one criteria. Any idea on how to return a value based on 3 criteria. tks
--
lucky
|