I need an Excel Macro or VBA expert

The project is an excel sheet with data of around 2,000 rows and 10-15 columns. A column of this data has to be transformed based on the values of a lookup table and then row by row a calculation has to be done using this column and a couple of other columns and added to a new column. The project is not complicated in excel processing terms neither on the calculations needed. But it can not be done manually due to the volume of the data. I have been a Macro writer earlier on in my career so I will be able to discuss with the programmer what is needed to make a solid macro. There is also some urgency on this. By the time I commission the job, it will have to be ready within a week maximum. Thank you.