| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup misses the first entry in table
If I insert a row with a number less than 074 first, the 074 does as I expect
on my spreadsheet. However, if I have it as is below, any lookup to 074 returns n/a, however the rest of the numbers below return as I expect. What am I missing in order to not put in a line I really don't need? ISBN Category 074 Books 078 Books 088 Books |
|
#2
|
|||
|
|||
|
use vlookup or hlookup
vlookup(lookupvalue,rangeToLookup,columnTo_lookup, false) The false indicates the lookup range is not in order. Lance "Spunky" wrote: If I insert a row with a number less than 074 first, the 074 does as I expect on my spreadsheet. However, if I have it as is below, any lookup to 074 returns n/a, however the rest of the numbers below return as I expect. What am I missing in order to not put in a line I really don't need? ISBN Category 074 Books 078 Books 088 Books |
| 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 | |||
| Double entry lookup | Excel Worksheet Functions | |||
| Index table lookup anomaly | Excel Worksheet Functions | |||
| Lookup Table | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
