| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference answer
worked exactly as i needed, thanks
"andy62" wrote: It sounds like you could use the VLOOKUP function to pull in the speed and acceleration once the gradient is typed in. It will look for the gradient in the first column of the reference table and pull in the data from another column you specify. Follow the instructions in Excel Help to apply it to your situation, and write back if stuck. "philiy" wrote: i want to have cells that get their answer by cross referencing another cell. i want 2 different cells to get an answer when the cell beside them is given a certain value. for example. i am given an inclines gradient which means a vehicle can only go a certain speed and a certain acceleration due to this gradient. i want to set up a system where i put in a gradient value and the two cells beside it produce values for speed and acceleration. there is a table on a constants page with a list of gradiants and beside the list of gradiants is the list of speeds and accelerations related to that gradient.any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =D6-E6. Answer in F6. I want answer in F6 only if value in E6? | Charts and Charting in Excel | |||
| not following your answer | Excel Discussion (Misc queries) | |||
| HOW TO GET AN ANSWER | Excel Discussion (Misc queries) | |||
| Same row different Answer. | Excel Worksheet Functions | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Hybrid Mode
