=INDEX($C$13:$C$24,MATCH(1,N((N($A$13:$A$24=A3)*ROW($A$13:$A$24)*N($B$13:$B$
24>=$B3))>0),0))
With CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vikas Agarwal
Sent: 06 September 2012 12:2
It looks like your "Item Master" rates are based on a Date.
However, the dates in the Sales Register don't match up with the dates in the
Master.
Is this simply because it's sample data?
What is the relationship between the Product Code, Date, and Rate?
Is the Rate established on a date and appl
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
