Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |