Vlookup inside a loop

[sur.saini]

I want a function by which i pass the range of complete table as range and date. which give me the total of sales till date. I have a table which contains whole ,month dates and sales which i feed on regular basis. suppose if i select 5 May 11 then it give me total sale till 5 may 11.

[TMS]

Want to share a sample of your data? In a workbook, with whatever formulae and code you already have.

Regards