Take a look at VLOOKUP in XL Help. For example, if your lookup value is
in J1, and your table is in A:D, then:

=VLOOKUP(J1, A:D, 4, FALSE)


In article ,
cindy wrote:

I am working on a spreadsheet and I want to enter a number from a table and
have the associated values from the table transfer with the number into my
spreadsheet. What functions and formulas should I use? (Below is the Table,
the PTM# is the one I would query for.)

X L/R Y PTM#
0.54 R 0.58 20
0.82 R 0.50 21
0.66 R 0.73 22
0.06 L 0.27 23
0.03 R 0.13 24
0.55 R 0.29 25