Forum Discussion
Value not available error for Index match formula..
Hiren1993 Your sheet contains rounding differences. for instance, in F29 you are trying to match 0.91 with 0.910000000000001 in B72. It doesn't. Hence, the NA# error.
Clean-up column B (i.e. get rid off the extra decimals). In column G you also need to write the formula to become like this:
=ROUND(SALE!E2,2)This ensures that Excel picks-up two decimals from the sales sheet as well.
A cleaned file is attached.
Hiren1993 Your sheet contains rounding differences. for instance, in F29 you are trying to match 0.91 with 0.910000000000001 in B72. It doesn't. Hence, the NA# error.
Clean-up column B (i.e. get rid off the extra decimals). In column G you also need to write the formula to become like this:
=ROUND(SALE!E2,2)This ensures that Excel picks-up two decimals from the sales sheet as well.
A cleaned file is attached.
Thank You