Ok here it goes below is a copy of code which is in around 2000 cells, but each cell has a different cell address, i would like all the cell addresses within the formula to be changed to absolute via a macro so that i don't have to do it manually, and help would be greatly apprieciated
=IF(LEFT('Master Roster'!$C3,2)="RN",VLOOKUP('Master Roster'!$E3,RN_shiftcode_table,3,FALSE),IF(LEFT('Master Roster'!$C3,2)="EN",VLOOKUP('Master Roster'!$E3,EN_shiftcode_table,3,FALSE),IF(LEFT('Master Roster'!$C3,2)="PC",VLOOKUP('Master Roster'!$E3,PCW_shiftcode_table,3,FALSE),IF(LEFT('Master Roster'!$C3,1)="D",VLOOKUP('Master Roster'!$E3,DON_shiftcode_table,3,FALSE),IF(LEFT('Master Roster'!$C3,2)="TH",VLOOKUP('Master Roster'!$E3,TH_shiftcode_table,3,FALSE),"USC")))))