I have a financial statement that has the same account on different rows for different years. How can I pick up the second or third occurrence using a vlookup, index/match, etc? The layout of my data is below. As an example, I normally use =VLOOKUP(Q4,A:M,2,FALSE) with 2 representing the values for that specific period
Column A account number
Col B January Values
Col C February Values
Col D March Values
....
....
....
Col L November Values
Col M December values
Col N Year
Thanks for your assistance.
Column A account number
Col B January Values
Col C February Values
Col D March Values
....
....
....
Col L November Values
Col M December values
Col N Year
Thanks for your assistance.