Hi Guys,
i'm new here, so apologies if this has been asked before!!!
I am trying to do a vlookup that brings back all data associated with the "look at " data.
Now in the data attached I know that each one has 2 or 3 entries per code. But when I do the vlookup, it will only bring back the first instance. (I.E I know A5PS has two entries of arrived and finished time (14:29:00 and 09:49:00 on the same day)
Is there a way to show each code by day each arrival and finish time?
I've tried this, and it has bought back data, but I cna't work out where from?!?!
INDEX('Raw Report'!$AU$2:$AV$9972,SMALL(IF('Raw Report'!$AU$2:$AU$9972=Sheet2!C5,ROW('Raw Report'!$AU$2:$AU$9972)),ROW(Sheet2!5:5)),2)
as an array formula.
any help would be amazing
cheers
Donna
Bookmarks