View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Lookup based on criteria in 2 columns

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,