Search faciltity and H/VLOOKUP

Ooh the mental torture of being ignorant.

I have spent the last week searching this forum to find the solutions to my various problems, I'm in mental meltdown

I don't think that I can explain here what it is I need so I have attached a sample workbook/spreadsheets.

I have NO experience of Excel and have had a little help developing the attachment, my assistant has now gone AWOL

Any/all help is extremely grateful.

Ak