Hello,
I am using vlookup to return the "Sales" for a particular "Location"
depending on the Yr. My result is always the sales for the first year, which
I assumed is what would happen. Is there any way around this?

Location Yr Sales
12345 2008 100,000
12345 2007 150,000
12345 2006 125,000

Thanks for the help.