Find a word within a range and return contents of a different cell in excel

[shina67]

Hi,
Hope someone can help with the problem I have within a workbook.
I need a formula to insert into A21 through to A53 that will find the date from A1, in worksheet 'Holidays' row 1 then search that column for "h" or "hh" and return the name from column B. Also I need a similar formula to insert into B21 through to B53 that will find the date from A1, in worksheet 'Holidays' row 1 then search that column for "s" and return the name from column B. Hope this makes sense. I can't insert images to help with my explanation, sorry.

<tbody>
</tbody>

 

[shina67]

Thanks again Andrew works a treat and when copied down. Don't know if I am being thick or just have a mind blank but what part of the formula do I have to change to copy across?

Or maybe there is a macro that will do the same?

 

[Andrew Poulsom]

You mean to use the date in A2?