A1 notation is the standard for our organization, so I'm looking for an

answer that maintains A1 notation.

I have a cell that contains a number (20 to 115 or higher). I need to pull a

value from the associated column.

So, I have a reference cell B1 that contains the number 27, and I need the

number in row 11.. I start my destination cell formula with:

=indirect("AA" & "11")

Now I need to replace the "AA" with a link to the source cell (B1,

containing the number 27), but transmute the number so that it returns

columns T through however many columns are used (AA, AF, BR, etc.). What is

the best way to do this if forced to maintain A1 notation?

=indirect(what_goes_here(B1) & "11")

Thanks!

Keith

--

The enclosed questions or comments are entirely mine and don't represent the

thoughts, views, or policy of my employer. Any errors or omissions are my

own.

## Bookmarks