| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup a value on a table
I have the following table:
3 2 1 0 -1 -2 < 4.6 A A-B B D E F 4.6- 6.9 A-B B C D E F 9-11.5 B B-C C D D E 11.5-13.8 C C-D D D D D 13.8 C D D D D D I want to find, for example, what letter corresponds to (5,-1). I expect a letter "E" to be the answer, but I have no idea how to write the formula. Help!!! |
|
#2
|
|||
|
|||
|
Can you split up the first column into min and max for the range? If so, it
would be a lot easier. "Gaby L." wrote: I have the following table: 3 2 1 0 -1 -2 < 4.6 A A-B B D E F 4.6- 6.9 A-B B C D E F 9-11.5 B B-C C D D E 11.5-13.8 C C-D D D D D 13.8 C D D D D D I want to find, for example, what letter corresponds to (5,-1). I expect a letter "E" to be the answer, but I have no idea how to write the formula. Help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Multiple table lookup | Excel Discussion (Misc queries) | |||
| How do I lookup a table from right to left ? | Excel Worksheet Functions | |||
| Index table lookup anomaly | Excel Worksheet Functions | |||
Linear Mode
