Folks - My name is Terry McCoy, and this is my first time on this forum. I have been reading the message boards, but this is my first post. I am getting an error message in a spreadsheet, and am hoping someone can illuminate me.
I am using a spreadsheet in Excel 2007. It has worked fine in the past, but I recently did a "Save As" to copy it and input different data. The spreadsheet has an "Hlookup" formula in it, and it is giving me an =N/A error and says the "Value is not available". I hate it when that happens. There are other "Lookup" formulas in the worksheet and they seem to be ok. The "Hlookup" formula refers to a dual variable table. The references all seem to be numbers, not text. The formula has "False" for the range lookup argument, which seems to be why I am getting N/A. I changed it to "True", and the formula returned a value, but it is not the value I want. It is the value directly less than the exact match I am looking for. From what I can tell, the lookup value argument (in this case 7.50%), and the comparison value I am looking for (also 7.50%) are exact matches, but the formula seems to think the comparison value is more than 7.50%. I have no clue why. The comparison values derive from another cell where 7.00% is entered, and then 0.0025 is added to 7.00% to create a range of interest rates. I used the LEN function, and the lookup value argument and comparison values seem to have the same number of characters. I would appreciate any suggestions, tips, comments or whatever.
Thank you very much.
Terry McCoy.
I am using a spreadsheet in Excel 2007. It has worked fine in the past, but I recently did a "Save As" to copy it and input different data. The spreadsheet has an "Hlookup" formula in it, and it is giving me an =N/A error and says the "Value is not available". I hate it when that happens. There are other "Lookup" formulas in the worksheet and they seem to be ok. The "Hlookup" formula refers to a dual variable table. The references all seem to be numbers, not text. The formula has "False" for the range lookup argument, which seems to be why I am getting N/A. I changed it to "True", and the formula returned a value, but it is not the value I want. It is the value directly less than the exact match I am looking for. From what I can tell, the lookup value argument (in this case 7.50%), and the comparison value I am looking for (also 7.50%) are exact matches, but the formula seems to think the comparison value is more than 7.50%. I have no clue why. The comparison values derive from another cell where 7.00% is entered, and then 0.0025 is added to 7.00% to create a range of interest rates. I used the LEN function, and the lookup value argument and comparison values seem to have the same number of characters. I would appreciate any suggestions, tips, comments or whatever.
Thank you very much.
Terry McCoy.