*Sigh* I meant to say that the formula in Cell C5 is: =VLOOKUP(B2,B4:C13,2)

"SongBear" wrote:

maestro
Generally speaking, yes there are a couple of ways to go.
For instance if your table is one column of text lables and one column of
values, then you would use a VLookup function.
There is a very good explaination of VLOOKUP in Excel help, along with other
table lookup functions.
Example:
the formula in cell I5 is: =VLOOKUP(B2,B4:C13,2)

B C
5 text6 753
6
7 text1 122
8 text2 211
9 text3 321
10 text4 123
11 text5 456
12 text6 753
13 text7 159
14 text8 951
15 text9 357
16 text10 852

Please let us know if this answers your question.
If you need more help or clarification, let us know.
SongBear

"maestro" wrote:

I have a data table with text fields and associated values. In another part
of the spreadsheet I need for Excel to match a text entry (when I type it) to
the table and copy the associated value to another cell in the worksheet. Is
this possible?