Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi-
I have created a lookup table with 12 rows and 28 columns. (I'll call row values "z*" and the column values "A"). In my spreadsheet, z* and A are computed in previous cells. To use the lookup table with its discrete values of z* and A, I have been rounding the calculated values of z* and A to match the values in the columns and rows of the table. I have been using a combination of "INDEX" and "MATCH" commands created by the lookup wizard to look to the rounded z* and A values, and return the proper table value. My confusion lies in the fact that for all values of z* except for two of them, everything works great. For the two problem values values, I get the #N/A error. Any help would be greatly appreciated. Let me know if I need to provide more info. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
If statement w/ rounding but not all numbers | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) |