Re: Data table function

Hi

Assuming the cell you enter Blue widget is D2 and you want the price
returned in E2.
In cell E2
=VLOOKUP(D2,$A$B,2,0)

If you wanted to do in on another sheet, say Sheet2, but with your
lookup table on sheet1, then
=VLOOKUP(D2,Sheet1!$A$B,2,0)

--
Regards

Roger Govier


"maestro" <maestro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F72E5BDB-998A-4AD5-997E-0C7935C03811@xxxxxxxxxxxxxxxx
I think I did a poor job of explaining myself. My apologies. I plan to
have
a table like you described with a column of text and a column of
associated
prices.
Example:

A B
blue widget $15.95

These columns will contain dozens of rows. When I type "blue widget"
somewhere else on the work***, I want it to bring up the associated
price
and drop it into another cell.

Does this make sense?

Regardless, thank you very much for responding so quickly.

Maestro

"SongBear" wrote:

*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 spread*** 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
work***. Is
this possible?


.