<t>I have some questions regarding macro in excel. Let suppose I have a huge table of data and I want to extract info. from it by using, say, VLOOKUP function in vba. (i.e. key in the ID, and I can get, say date and price). Nonetheless, my table contains loads of dates (same ID appears on 20 days, f...