| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two way lookup on a table from user input
I have a table that lists my different specs in column one. I want a formula
that will read the spec that is keyed in by the user and then also read the spec gravity number keyed in by the user and then look up the spec column and follow that row across until it comes to the column with the user entered spec gravity number. At this intersection, there will be a number that is needed to figure pounds of material. -- Kim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prompt user for input and utilize that input | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Forcing Input from a user | Excel Worksheet Functions | |||
| user input function | Excel Worksheet Functions | |||
| INDEX, user input? | Excel Worksheet Functions | |||
Threaded Mode
