The columns in your rates table need to be switched. What you are searching for, the QAR code, should be in the leftmost column and what you want returned, the QAP code, should be in some column to the right.

What is it you are trying to do here? Correct codes that are incorrectly entered?

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.