Hi, I'm relatively new to excel and would appreciate any help with th following problem. I'm working on a pensions spreadsheet and need to work out income a retirement over a set period. I have tables which have all the require formulas and a manual goal seek works fine if I enter the set cell o the corresponding period entered by the customer. Unfortunately th period can change, i.e. some may want the income for 15 years, others 2 years or whatever. I realise to automate this I need a macro but I don't know how to d this with a variable set cell. I've tried with vlookup but that doesn' work. I've worked out a formula to give me the location of the set cel but again have no idea how to get this to work with a goal seek macro. Column A has the number of years (1-30) Column B has the annual income Column C has the total fund value So if required period 15 years the Set Cell would be C15, if 20 years C20, etc. Goal Value would be 0 Changing Cell would be B1 Hope you can help before I pull all my hair out