Help with a fomula in Excel

[indupriya9]

I have a formula in excel that needs to be modified. The formula is as follos

         formula = "=IF(ISERROR(MATCH(RC6,TraineeUnits!R" & unitStartRow & "C" & traineeUnitIndex & ":R" & unitEndRow & "C" & traineeUnitIndex & ",0)),"" "",IF(AND(VALUE(INDEX(TraineeUnits!R" & unitStartRow & "C" & traineeUnitIndex & ":R" & unitEndRow & "C" & traineeUnitIndex & _
                    ",MATCH(RC6,TraineeUnits!R" & unitStartRow & "C" & traineeUnitIndex & ":R" & unitEndRow & "C" & traineeUnitIndex & ",0)+1,1)*10)>=R" & "C" & 6 + traineeUnitIndex & ",VALUE(INDEX(TraineeUnits!R" & unitStartRow & "C" & traineeUnitIndex & ":R" & unitEndRow & "C" & traineeUnitIndex & _
                    ",MATCH(RC6,TraineeUnits!R" & unitStartRow & "C" & traineeUnitIndex & ":R" & unitEndRow & "C" & traineeUnitIndex & ",0)+1,1)*10)<=R[-]C" & 7 + traineeUnitIndex & "),R[-]C" & 4 + traineeUnitIndex & ","" ""))"

The value from the bit =R" & "C" & 6 + traineeUnitIndex & ", returns a value for eg $G8. I would like to change this to $G$8.

Similarly the value from the bit R[-]C" & 7 + traineeUnitIndex & "), returns a value $H8. I would like to change this to $H$8.

Can anyone please let me know how to change this in the formula?

Thanks in advance

ip

 

[misterstick]

the square brackets indicate the relative reference: take them out and you'll be away.

absolute: RC1 == $B$1
relative: R[-]C[1] == B1



mr s. <