| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to do a Vlook up givin two conditions
i need to look a value who conteins more than two conditios
example store hour sells 5001 1 12,000 5001 2 14,000 if i look a value in this table i have to introduce more than one condition ina Vlookup formula which are store and hour, but i dont now how two indtroduce two conditios in a vlookup formula |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to do a Vlook up givin two conditions
Hi!
Try this: =SUMPRODUCT(--(A1:A10=store),--(B1:B10=hour),C1:C10) Better: D1 = store = 5001 D2 = hour = 2 =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=D2),C1:C10) Biff "Gabriela" wrote in message ... i need to look a value who conteins more than two conditios example store hour sells 5001 1 12,000 5001 2 14,000 if i look a value in this table i have to introduce more than one condition ina Vlookup formula which are store and hour, but i dont now how two indtroduce two conditios in a vlookup formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
| Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| average on 2 conditions | Excel Worksheet Functions | |||
Linear Mode
