Hello everyone,

Lets suppose I have a series of numbers in column A that correlate to a
sentence (in colum B) such as below (in actuality I have 64, for the
sake of this example I have 3):

1148 Today is a sunny day
1189 Tommorow will be rainy
1194 Yesterday was windy

Now, I would simply like cell (say) C5 to display "Today is a sunny
day" if cell B6 displays the corresponding code (1148).

I have worked on this all day and have come up empty, I would
appreciate any ideas. Thanks so much


--
mikeyVo
------------------------------------------------------------------------
mikeyVo's Profile: http://www.excelforum.com/member.php...o&userid=34277
View this thread: http://www.excelforum.com/showthread...hreadid=540412