Hi Everyone,
Simple question & can supply a test document if needed...but hopefully a description should be adequate.
Column A...contains an ID for a task - appearing multiple times as you descend the column.
Column B...a corresponding date at which each task has appeared or re-appeared - but which lookups to another worksheet where the data has been pulled from another source with successive columns containing manually-entered information.
Using a standard vlookup obviously only pulls through the first date for each ID...I need each successive appearance to have it's appropriate date.
(in columns c,d,e,f etc. I also have to pull data from the other sheet - again only pertaining to that particular instance of the ID occuring).
As ever,any help appreciated