Two Reference Cells in VLOOKUP, Probably easy but ....

R

Ross

Hi,

I want to make a formula probably using Vlookup, but not necessarily, that
uses two reference cells, i.e a date and a line number, looks at another
table matches the correct values to the required reference cells and returns
some other required data.



Line Date Required Field
A 01/06/2006 1
B 01/06/2006 2
C 01/06/2006 3
A 02/06/2006 4
B 02/06/2006 5
C 02/06/2006 6


i.e I want the required field to be returned when I stipulate that I am
looking for Line "B" and Date"2/6/06" and returns the number "5"

This is probably very easy but I'm afraid I just don’t know how to do it.

Many Thanks,
P
 
M

Marcelo

Hi Ross,

try =sumproduct(--($A2$2:$A$100="B")*($B2$2:$B$100=date)*($C$2:$C$100))


HTH
regards from Brazil
Marcelo

"Ross" escreveu:
 
M

Marcelo

Hi Ross,

try =sumproduct(--($A2$2:$A$100="B")*($B2$2:$B$100=date)*($C$2:$C$100))


HTH
regards from Brazil
Marcelo


"Ross" escreveu:
 

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

Check if a date comes before/after a range of dates 0
match then return a value 5
Calculation in Date Range 1
VLOOKUP Problem 1
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria 2
Some date/time cells appear in different format 3
to link information between two lists 16
pivot table formulas for calculated field or calculated item 3

Top