@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.
