Here is how to use the ADDRESS function along with ROW, COLUMN, INDIRECT and Data Validation In Excel:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
This post will show you some of the details of the ADDRESS function and how you can incorporate it along with INDIRECT, ROW, and COLUMN functions plus add in some Data Validation. Here is the end result:
Watch the video to see how we got there!