Lookup Formula

Hi.

I hope someone can help.

I need H2 to lookup datum in Column B. The hard part is the lookupvalue and the datum is in one column

Please see attachment for more information.

I appreciate all the help.