LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mikeyVo
 
Posts: n/a
Default an odd question-cant figure out a formula


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Question Formula Question Excel Discussion (Misc queries) 2 April 23rd 06 12:00 AM
Excel formula question bb Excel Discussion (Misc queries) 3 April 20th 06 03:11 AM
Question about the "Match" formula Ltat42a Excel Discussion (Misc queries) 3 February 21st 06 11:56 PM
I have a question regarding countif formula. Fahad Farid Ansari Excel Worksheet Functions 6 October 1st 05 11:57 PM
formula question Pam Coleman Excel Worksheet Functions 9 April 11th 05 08:51 AM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"