| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get correct results when LOOKUP with calculated numbers
I am using LOOKUP and VLOOKUP to lookup data on tables. I have done this
successfully, but I get unusual results when looking up calculated values. Sometimes the lookup results are correct sometimes not. All values are numbers, lookup_vector is in descending order. Lookup works when value is typed in cell not calculated. Unfortunately I need to lookup the value calculated from a lookup value. calculation is simple ie =D2+0.1 I am specifically looking up the values less than and greater than the lookup_value. I have been looking up the less than value then adding 0.1 to get the greater than value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with multiple results, without duplicates | Excel Worksheet Functions | |||
| Can Function results be calculated? | New Users to Excel | |||
| Lookup Returning Multiple Results | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Alphabetical list of Numbers are not correct! | Excel Discussion (Misc queries) | |||
Threaded Mode
