| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
I've tried rounding both the lookup table and the value in case this was a
rounding issue. The stranger thing is that VLOOKUP works for *most* values, but every 4th (or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works, 101.45% works but 101.50% doesn't) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
Hi
Maybe its just a empty space before your numbers,you can't see it but will give you in return #na as a result. Check it HTH John "iguttin" wrote in message ... I've tried rounding both the lookup table and the value in case this was a rounding issue. The stranger thing is that VLOOKUP works for *most* values, but every 4th (or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works, 101.45% works but 101.50% doesn't) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?
Hi,
Probably still a rounding error. The default vlookup is =. So if the cell value is 101.499999999 but displays 101.50 Excel will return the 101.45% John "iguttin" wrote in message ... I've tried rounding both the lookup table and the value in case this was a rounding issue. The stranger thing is that VLOOKUP works for *most* values, but every 4th (or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works, 101.45% works but 101.50% doesn't) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: VLOOKUP returns #N/A for a sorted value that exists?? W
The numbers I'm using for the table and within the lookup were generated
using a formula (ie. value above + 0.05%) so they don't have empty spaces. "John" wrote: Hi Maybe its just a empty space before your numbers,you can't see it but will give you in return #na as a result. Check it HTH John "iguttin" wrote in message ... I've tried rounding both the lookup table and the value in case this was a rounding issue. The stranger thing is that VLOOKUP works for *most* values, but every 4th (or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works, 101.45% works but 101.50% doesn't) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: VLOOKUP returns #N/A for a sorted value that exists?? W
Hi
Your formula Vlookup "Range Lookup" is it set to "False" exact match, if so then it looks like a rounding error. just for trial switch the function to "True" and see what you get. HTH John "iguttin" wrote in message ... The numbers I'm using for the table and within the lookup were generated using a formula (ie. value above + 0.05%) so they don't have empty spaces. "John" wrote: Hi Maybe its just a empty space before your numbers,you can't see it but will give you in return #na as a result. Check it HTH John "iguttin" wrote in message ... I've tried rounding both the lookup table and the value in case this was a rounding issue. The stranger thing is that VLOOKUP works for *most* values, but every 4th (or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works, 101.45% works but 101.50% doesn't) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 VLOOKUP in another workbook returns #VALUE | Excel Worksheet Functions | |||
| VLOOKUP returns #N/A | Excel Worksheet Functions | |||
| Vlookup returns #N/A | Excel Discussion (Misc queries) | |||
| Why must the table for Vlookup be sorted in ascending order? | New Users to Excel | |||
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
Linear Mode
