Return multiple results for a vlookup using the range "TRUE" argument

[Lazarus7]

HI all,

I'm having an issue returning multiple results for a vlookup I'm using to tell me all instances that have occurred for a certain time period.

What I have is a certain point in time in one sheet that I need to know all the downtime events that were occurring at that point in time. My data I'm looking at is in sequential order and has the downtime events occurring with a start and end time.

Currently I'm using this formula =VLOOKUP(B2,'A1 Downtime'!$E$4:$G$113,3,TRUE) where B2 is the point in time I am looking at, column E has the start time of the event, column F the end time of the event & column G the description of the event. I've converted my date & times into numbers.

At the moment I am getting the first result but on quite a few occasions there is actually more than one downtime event occurring at that single point in time, so I want to return all events that are happening at that time.

Sorry for the long winded post, any ideas?

Thanks

 

[Joe4]

I have merged your two threads together.

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).