Wednesday, April 10, 2013

yogi_Find The Purchase Price Based On The Earliest Transaction From A Multi Transaction Database


                                          Google Spreadsheet   Post  #1106
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 10, 2013
user Unfortunatetoast :(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!mydiscussions/docs/ZAmTXjSImg8)
Cell value based on multiple criteria including earliest date
I need to find a formula for the following scenario:

Sheet1:
column A: VIN numbers (like a product code)
column B: Date Sold
column C: Purchase price
(Many of the VINs are entered several times, each with a different Date Sold and Purchase Price)

Sheet2:
column A: Enter a VIN number here to find the original purchase price
column B: This is where I need a formula. I need to go through each match of a VIN from column A on this sheet to column A on Sheet 1. Find the earliest Date Sold and return the purchase price on that row.
---
Sure. Here you go. The formula I need is on sheet2. Thank you so much!

---------------------------------------------------------------------------------------------------
following is a solution to the problem