012 12:21
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Invoice rate verification
Hi All,
Need your help.
I have Item Master (which has effective date of price applicable for a
product) and Sales Register (actual date of invoice with item and price
charged).
I need to check in
can.” - John Wesley
-
From: Vikas Agarwal
To: excel-macros@googlegroups.com
Sent: Thu, September 6, 2012 2:51:13 AM
Subject: $$Excel-Macros$$ Invoice rate verification
Hi All,
Need your help.
I have Item Master (which has effective date of price applicable for a product)
and Sales Regi
Hi Vikas,
You can use Lookup formula.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 12:21 PM, Vikas Agarwal wrote:
> Hi All,
>
> Need your help.
>
> I have Item Master (which has effective date of price applicable for a
> product) and Sales Register (actual date of invoice with item and price
Hi All,
Need your help.
I have Item Master (which has effective date of price applicable for a
product) and Sales Register (actual date of invoice with item and price
charged).
I need to check in Sales Register whether the rate applied is as per Item
Master.
Sample file attached. Please assist.