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:

Salary	2000
Salary	1000
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.

------------------------------------------------------------------------------------------------------------------------------------------------