Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
sorry, yes I wan the quantity to show according to the 3 criteria I would
have entered. tks -- lucky "akphidelt" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Put this in D3 of Sheet2:
=SUMPRODUCT((Sheet1!A1:A100=B2)*(Sheet1!C1:C100=B3 )*(Sheet1! D1:D100=B4)*(Sheet1!B1:B100)) I've assumed you have up to 100 rows on Sheet1 - adjust this if you have more. Hope this helps. Pete On Aug 21, 10:56*pm, luckyie wrote: sorry, yes I wan the quantity to show according to the 3 criteria I would have entered. tks -- lucky "akphidelt" wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |