Holiday range lookup?

Hi folks,

Well I need a little help, iv attached a shortened version of what im trying to do with test data, don't laugh! iv only been doing the vb bit for a few months and its rather simple.

What i need to do is when the availability button is clicked on the employee sheet, it will lookup the employee from whats been selected and check against the holiday sheet (which will be hidden later on) and check from the from and tofrom dates from the button and possibly return just a 'yes' in a cell two down from the button, or possibly just a Yes or No in a msgbox.

Iv attached my example, eventually this will include a lot more employees etc. Iv been racking my brain today and must be having a thick day as I can't figure it at all.....

Thank you in advance