Excel cell value from address

I know I'm doing something dumb. I have a vector of row numbers. I can use them and column numbers in the ADDRESS function to return Excell addresses containing a number I want to get, e.g., ADDRESS(...