| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup table
I have a table setup much like this.
TW Sq Ft 0-255 1 .743 2 .745 3 .746 4 .748 If I enter a value of 245 and 4 I want it to return .748 because it is between 0 and 255 and a TW of 4. Im lost. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
| In Excel 2003 how do you get a table to update based on lookup cr. | Excel Worksheet Functions | |||
| How do I lookup a table from right to left ? | Excel Worksheet Functions | |||
| Index table lookup anomaly | Excel Worksheet Functions | |||
| Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
