Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup with two criteria
I want to look up data that has two criteria.
eg. store number Date Value 262 Jan 8/2005 8 262 Jan 15/2005 4 262 Jan 22/2005 8 263 Jan 8/2005 7 263 Jan 15/2005 6 How do I get the "value" for store 262 for Jan 8th?and the "value for store 263 for Jan 8th? any help is appreciated. Thanks |
#2
|
|||
|
|||
one way is to add a column duplicating the values
then vlookup(value,a2:b10,2,false) for the date from value and vlookup(date,b2:c10,2,false) for the value from date "BJ" wrote: I want to look up data that has two criteria. eg. store number Date Value 262 Jan 8/2005 8 262 Jan 15/2005 4 262 Jan 22/2005 8 263 Jan 8/2005 7 263 Jan 15/2005 6 How do I get the "value" for store 262 for Jan 8th?and the "value for store 263 for Jan 8th? any help is appreciated. Thanks |
#3
|
|||
|
|||
=INDEX(C:C,MATCH(262&Date(2005,1,8),A1:A100&B1:B10 0,0))
-- HTH RP (remove nothere from the email address if mailing direct) "BJ" wrote in message ... I want to look up data that has two criteria. eg. store number Date Value 262 Jan 8/2005 8 262 Jan 15/2005 4 262 Jan 22/2005 8 263 Jan 8/2005 7 263 Jan 15/2005 6 How do I get the "value" for store 262 for Jan 8th?and the "value for store 263 for Jan 8th? any help is appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup - double criteria | Excel Worksheet Functions | |||
Vlookup - double criteria | Excel Worksheet Functions | |||
Vlookup - double criteria | Excel Worksheet Functions | |||
SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
VlookUp with Multiple Criteria? | Excel Worksheet Functions |