Could an expert provide me with the formula to do a Vlookup then perform a calculation.
Assume we start on Sheet1 on "E2"
i.e. Vlookup the Ref in A2 [Sheet1] on sheet3 column 'A', if it is there in Sheet3 find the number in column 'C' and then increase the date in Sheet1 by that number of months.
So. If my date in Sheet1 is 14/3/2014 and the number in Sheet 3 is 4 put 14/7/2014 in column 'C' in Sheet1
So. If my date in Sheet1 is 14/3/2014 and the number in Sheet 3 is 12 put 14/7/2015 in column 'C' in Sheet1
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…