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 muc