Sure there is .. use a mixture of Lookup and left and get your result.

I am going to assume your lookup table is A1:B50 (A1 and B1 are
titles)

=LOOKUP(LEFT(C1,4),$A$2:$A$50,$B$2:$B$50)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549077