On the formulas tab, in the function library group, click the lookup & reference button, and select VLOOKUP. type A4 in the lookup value agreement box. type abbreviation in the table array argument box. type 2 in the col num argument box. type false in the range lookup box. click okay