an odd question-cant figure out a formula

[mikeyVo]

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

[Harlan Grove]

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)

[Ron Coderre]

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

[mikeyVo]

wow, that did it! thanks very much