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

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