Check out Chip Pearson's site:
http://www.cpearson.com/Excel/TablesAndLookups.aspx

Look for "Arbitrary Lookups"

wrote:

<<snipped
Thank you for the response. That is what I feared. I am unable to
manipulate the layout of the table, as it is a canned report that is
spit out of an online system, and we would like our users to as little
manual manipulation as possible. Do you know of any other formulas
that could help with this?

--

Dave Peterson