My first post.
-----A-----B-----C
(1) 5280 5,000 1/01/03
(2) 5280 6,000 2/01/03
(3) 5280 9,000 5/01/03
If I use a VLOOKUP for the above data it will return the value of the first found instance of 5280 of 5,000 on 1/01/03 from Row 1.
I looked in the Excel Help file but found limited advise.
Is it possible to modify or nest the VLOOKUP to find the second instance and/or even the third? If so, can you provide an example?
My spreadsheet contains 780 rows involving over 50 different dates but for each item listed in column A there are no more than 4 instances of like individual items.
Perhaps an "IF" statement nested in the VLOOKUP?
I suspect it simply can not be done but it sure seems like it should be possible. I do not know how. :no: