VLookup then calculate
Posted on 2014-02-06
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
Hope this is clear.