Setting cell reference as variable.

Hey all,

This is what I want:

Please Login or Register  to view this content.

The code obviously doesn't work but the aim of the code is to Reference Column "M" but have the row reference variable depending on a number within Cell "A1". Can this be done?

EDIT: I know this code below will work but IF statements can only go so far...

Please Login or Register  to view this content.

Hi,

Try this:

=INDIRECT("M"&A1)