yes use array formula.
This will be a lil bit tricky.

Here is a site for your reference (See Arbitrary Lookups) :
http://www.cpearson.com/excel/TablesAndLookups.aspx