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

an odd question-cant figure out a formula
 

mikeyVo wrote...
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).
....

Have you considered VLOOKUP?

C5:
=VLOOKUP(B6,A1:B3,2)

an odd question-cant figure out a formula
 

Try something like this.....

With your table of Codes/Phrases in A10:B100

B6: (a code value )
C5: =VLOOKUP(B6,A10:B100,2,0)

Does that help?

Regards,
Ron


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

an odd question-cant figure out a formula
 

wow, that did it! thanks very much


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