multiple lookup

thanks for quick response,
Johns reply works perfectly
When I try marvins method it returns Result!B2 as answer. i am looking into it as where i am doing mistake.
how do I mark it as solved