HLOOKUP - Doesn't seem to like me :(

[EddieMcr]

Hello

I have been using vlookup for a few years. And have encountered for the first time a need for Hlookup.
But after toiling over it for hours ....am puzzled why it won't work for me

Basically I have an array on sheet 1 that I want to search for a string
this string comes from a listbox which refers to a list found on sheet 2 ..
and then if it finds this term in the row ..to return the email address ...also from the array

sounds simple? ..it probably is ....its just i have gone logic blind !
LOL

Please see attached example ..i hope you can see what I am trying to do

thanks in advance