I ' d say Steve is less Most interesting guy in the world and more guy who has a compulsion to explain everything including explaining why he needs to explain the thing he is explaining . Drives me crazy . Thank god Joe and Devon are as likeable and good as they are because Steve is close to insufferable . <| sep |> I ' ll just reply to say that I really find the horrid changes in names of most factions to be completely and utterly useless . <| sep |> You create a helper column A on your database sheet to create a unique value to avoid bringing back the first value you ' re not looking for . For example , If you ' re looking for apple sales on a certain date , your data will probably have three columns that show produce , date , and quantity . Insert a new column A on the data and combine the produce column and date column by using the B 1 C 1 formula . From there if you are looking for only Apple sales on a certain date you use use a vlookup that combines the produce and the desired date for example A 1 AppleB 1 DateVlookupA 1 B 1 , AA , 1 , falseEdit , I just realized I gave you a solution to how to FIND different values with a vlookup . What you ' re looking for is the Sumif formula , as mentioned by ucarrige