Combine items from two lists with a key field.
 

I have a workbook with grant numbers, dollar amounts and terms identifying
specific areas the grants address (CRISP terms). These terms are in three
categories (primary, seconday and tertiary) I have a second workbook of terms
I am using to search for grants that match up. I want the output to be a list
of grants, dollar amount, the term and which term category the match was in.

Would this be a macro problem or is there an Excel function that does this?

Thanks.