Hi Hemal,
You need Sales Qty against a purchase through RG which can easily retrieved
in attachment through sumproduct Note: Duplicates values in sales table is
summed !!
If you want to get all the details from sales table to purchase table,There
you need to mention Which row you want to ret
Use Index and Match Functions
It'll be easy...
Regards,
Vicky
On Tuesday, December 29, 2015 at 6:46:37 PM UTC+5:30, hemal shah wrote:
>
> HI
> All genius,
>
> In one sheet I have put purchases and in second sheet there is sales
> against purchase.
>
> In both sheets *RG* is unique id.
>
> In
