I am using the following formula to pull in info from a sheet named query3.
The info is linked by a name occurring in col I of each sheet..its coming from col AA.
=INDEX(query3!AA:AA,MATCH(I2,query3!I:I,0))
The sheet I am dragging from may contain more than 1 occurrence of the name with data columns.This sheet has the latest data..
Its newest to oldest.
I need to call up the penultimate occurrence and this name’s data and place to the right on the same row of my new sheet..and the third latest further to the right.
Any help greatly appreciated.
Bookmarks