Concatenate dragging formula down problem

[kelvinvu12]

So I have a formula like this:
=IF(AND(((INDIRECT(CONCATENATE("'",A$1,"'")))>(INDIRECT(CONCATENATE("'",A$1,"'", "!$K4")))),((INDIRECT(CONCATENATE("'",A$1,"'", "!$K5")))>(INDIRECT(CONCATENATE("'",A$1,"'", "!$K6"))))),(INDIRECT(CONCATENATE("'",A$1,"'", "!$K5"))),"")

It works however when I drag it down I want the 'K' value to increase by 1 row. For example when i drag the formula down, i want K4 to be K5 for the formula in the next cell. Right now, when i drag it down, the cell value does not change because it's in "". Can anyone help fix this?

Thanks!

[LeoTaxi]

like this K4 will increase

Please Login or Register  to view this content.

kind regards
Leo