Feb 15 2021 08:36 PM
Hello,
Please help me for the index match formula use.Please check the sheet 2...some value is showing value not available error with a same formula.
Please help...
Feb 15 2021 09:58 PM
Solution@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.
Feb 15 2021 10:06 PM
Thank You
Feb 15 2021 09:58 PM
Solution@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.