software

Hi-

I have created a lookup table with 12 rows and 28 columns. (I'll call row
values quot;z*quot; and the column values quot;Aquot;). 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 quot;INDEXquot; and quot;MATCHquot; 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.


When I tested this I got the same thing, although MROUND seemed to be
rounding correctly I didn't always get a match when it looked like it
should, I switched to ROUND and didn't get a problem, perhaps you can
do the same

=MROUND(A1,0.2) can be replicated with

=ROUND(A1/2,1)*2--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511981Thank you so very much! That worked perfectly, and saved me a lot more
confusion. I really appreciate it. Thank you.

quot;daddylonglegsquot; wrote:

gt;
gt; When I tested this I got the same thing, although MROUND seemed to be
gt; rounding correctly I didn't always get a match when it looked like it
gt; should, I switched to ROUND and didn't get a problem, perhaps you can
gt; do the same
gt;
gt; =MROUND(A1,0.2) can be replicated with
gt;
gt; =ROUND(A1/2,1)*2
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=511981
gt;
gt;