Forum Discussion
How to Post a Cumulative Rank for a Stock to Each Quarters Data
As SergeiBaklan has said, the third parameter in your use of VLOOKUP is the error. It should be consistently the number 2, i.e., the second column in the table in which you're seeking the corresponding rank of the company.
=VLOOKUP(C2,$C$2:$D$4,2,0)
mathetes Eureka! As Archimedes said. The Vlookup works now. I just had to adjust my range. Both your explanations are better than the Vlookup code description:
If you are MS Staff, MS feedback: To be clearer, I would have phrased this:
(lookup_value,table_range,lookup_col_no,{0=exact, 1=approx))
Thanks!
I'm glad you were able to make the VLOOKUP work with my correction to it; for the record INDEX and MATCH as suggested by SergeiBaklan would have worked too, given the right use of the several variables (to include the address of the range or array being searched). Those are all very powerful functions; there are other ways to retrieve data from tables, with those being perhaps the most common. You'd do well to familiarize yourself with them, and I think you'll find this on-line reference a good resource for your further learning.