Tuesday, August 13, 2013

yogi_Compute The Nth Instance Of Amount Associated With Specified Item

                                          Google Spreadsheet   Post  #1331
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 12 2013
user Anthony Sparks (http://productforums.google.com/forum/?zx=yefxq03jk0i0#!mydiscussions/docs/vcNNvOANAGI)
VLOOKUP() returning incorrect value
Using = VLOOKUP( "Salary",$A$1:B4, 2 ) to preform a search on this data:

Salary2000
Salary1000
Long Term
IRA Contribution-130
Yields: -130
Expected Value: 1000

Anyone else have a similar issue?
---
I need it to perform as Excel would, if you take the same data, same equation, different results. I don't want them to be sorted because they are in chronological order. I need the last instance of Salary that was introduced.
------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment