Hi Terry,

Post your formula, input vales and relevant table values. Is the table sorted?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Terry McCoy" wrote in message ...
| Folks - I am having a problem with a workbook in Excel 2007. I have what
| appear to be values, - numbers - in cells, but formulas are returning an #N/A
| error that the value is not available. I am getting the error from an
| HLOOKUP formula in one spreadsheet, and I was also getting it from another
| spreadsheet in the same workbook when I tried to use the average function and
| the array function. I used the "isnumber" function, and they are numbers.
| The HLOOKUP formula is referring to date in a table. It was working fine
| before, but now I am getting this error. This workbook is from another one
| that I "Saved As" and then changed the input. The formulas seem to be fine
| in the table. I have not been able to figure it out and would appreciate any
| insight.
|
| Thanks for your help.
|
| Terry McCoy