If Funtion column references

Need help with IF function, how can I change or increase certain number of columns for the reference in teh IF formula.

In the attached file when I copy the IF function from Q3 to R3 it should refer to Feb-Data (D3) instead of B3 and when I copy the formula in S3 it should refer to Mar-Data that is G3 and so on.

Thanks in advance.

Amar

Put this formula in Q3:

=IF(INDEX($A$3:$O$3,MATCH(Q1,$A$1:$O$1,0))=1,"Good",IF(INDEX($A$3:$O$3,MATCH(Q1,$A$1:$O$1,0))=2,"Average",IF(INDEX($A$3:$O$3,MATCH(Q1,$A$1:$O$1,0))=3,"Bad","okay")))

then you can copy the formula across.

Hope this helps.

Pete