how to do a Vlook up givin two conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlook-up in report with column Expansion 5
vlook up two column 4
vlook up 1
Vlook up problem 2
How do you do a VLookup with two conditions? 8
use if condition more than 7 times in a cell of office 2003 10
Conditional Formatting Confusion... 1
Weird prob: Format 3rd condition for other than first two 5

Back
Top