Insert a number into a function formula

This is what I need to do:
I'm using an "IF" function and I need to have the formula operate on a given row by changing one value in a different cell; for example.

Formula =IF(IK7<1," ",B17)
I would like to enter the number "7" in cell "A2" and have the formula read the "7" (in "K7") from cell "A2"

So if I entered 10 in cell "A2" the formula would then read:
=IF(k10<1," ",B17)

Any ideas?

--mark

Have a look at the INDIRECT function.

I looked at that but can't seem to get it to work embedded in an IF statement. Maybe I have the syntax wrong.

The formula is pointing to another sheet so it looks like this:
=IF('Regonline 6-30'!$L149<1," ",K17)
The value I would like to change by referencing another cell is "149"

Thanks

If the number 7 is in A2, then the formula =indirect("'sheet(1)'!K"&a2) will return the value in sheet(1)->K7. That should nest just fine within an IF function =IF(indirect("'sheet(1)'!K"&A2)<1,value if true,value if false)

Does that help?