View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cindy
 
Posts: n/a
Default Spreadsheet formula question!


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