Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
I am trying to use a vlookup or other function to return the value in the amount column based on the location and date. Here is a sample of my data: Location Date Amount 101 9/15/8 10 101 9/16/8 20 101 9/17/8 15 102 9/15/8 50 102 9/16/8 75 102 9/17/8 67 For example if I wanted to return the amount for location 102 on 9/15/8, what formula would I use? I tried using variations of vlookups but had no luck. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup based on 2 criteria | Excel Worksheet Functions | |||
Lookup based on two criteria. . . | Excel Discussion (Misc queries) | |||
Lookup based on 2 criteria | Excel Worksheet Functions | |||
Lookup based on two criteria in 1 row | Excel Discussion (Misc queries) | |||
LOOKUP value based on 2 criteria | Excel Worksheet Functions |