Hi

When your transfer table is p.e. on sheet MySheet in range MySheet!C2:F100,
and you want to look for a value in column F associated with a value in
column C, (you look for a value in PTM# column on row where p.e. X=0.03),
then
=VLOOKUP(0.03, MySheet!$C$2:$F$100,4,0)

The formula looks for value 0.03 in first column of referred range, and
returns a value from 4th column of this range, when there is an exact match.
When there is no exact match, an error is returned. To avoid the error, you
can use VLOOKUP with 1 as 4th parameter (then the nearest match is returned,
but your lookup table must be sorted on 1st column to get resonable results
at all), or you use an error traping:
=IF(ISNA(VLOOKUP(....)),"",VLOOKUP(.....))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"cindy" wrote in message
...

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