Yup, just use the VLOOKUP function in your formula.

If you attach a workbook, we could write the formula for you.