If range contains any of these values, return cell content & content of cell above

[yits05]

Hello - I have the following list of values I would like to search for in a dataset:

January

February

March

April

May

The dataset I would like to search looks like this

Experience:

ACME Inc

January 5 - March 30

Acme Corp

February 6 - May 13

gibberish

gibbering

Random Partners

April 6 - January 28

gibberish

I would like to extract from here the contents of the matching cells (date ranges), as well as the company name in the row above each match, and list them horizontally, with the answer appearing as:

ACME Inc

January 5 - March 30

Acme Corp

February 6 - May 13

Random Partners

April 6 - January 28

 

[Fluff]

Duplicate to: Search table for multiple lookup values, return all matches & their neighboring values horizontally

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.