Hello all,
Please guide me for the below issue.
In col A (Invoice#) I have some number, the same number in B (Invoice#) also but mixed.
In C having some amount which is for B's Invoice.
I need to find out A invoice related amount with the help of B.
For example A1 invoice# is C122, which in B352 amount 32,500.00. So in D1 has to print 32,500.00.
Some A's invoice# may not be there in B for that shout print NA.
Please give the solution asap.
Thanks and Regards,
Muthukumar
[email protected]
Bookmarks