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!
https://docs.google.com/
---------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment