What i am trying to do is conver the QAP code to the QAR code in column 2 in the Rate Summary. However if the reference code is already a QAR code i do not want to change it.

Does that make sense?

This is why i have the logical test on the IF statement referencing the P in the reference cell C5.