Create a table with your items from D in one column (I presume you
already have these as a list somewhere on the spreadsheet) and your
corresponding text in column to the right then you can just do a
VLOOKUP in column N

=VLOOKUP(D1,table,2,0)

you can either use INSERT NAME DEFINE to define your table name and
use in the formula or use the actual cell refs, e.g.

=VLOOKUP(D1,Y1:Z20,2,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511525