I would use the VLOOKUP function. You are going to have to move the PTM#
column to the far left of your table however (column A). Then lets say you
want the values to transfer to sheet2 and that you enter the PTM# in column A
of sheet 2. The formula would be like the following.

Assuming your first table is in cells Sheet1!$A$1:$D$7

=VLOOKUP(A1, Sheet1!$A$1:$D$7,2,0) Put in column B
=VLOOKUP(A1, Sheet1!$A$1:$D$7,3,0) Put in column C
=VLOOKUP(A1, Sheet1!$A$1:$D$7,4,0) Put in column D

Hope this helps.

Bill Horton

"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