Need list of cell #s to match Cell content

[DissGuy]

I cannot figure out how to make a proper formula for this issue....

In Columns A-M, I have of various numbers and text. In Column N I have a list of unordered cell numbers (B20, E12, L60, etc.). I want to make a formula for column O that will display the data associated with each of those cell numbers in column N.

Can anyone help me?

Thanks!

 

[Trouttrap2]

Maybe
=INDIRECT(N1) and drag down?

 

[DissGuy]

That works for the words, but not for the numbers. Any idea for the cells with numbers?

 

[Trouttrap2]

I guess I'm not sure what you want. If column N has (B20, E12, L60, etc.) as the value then indirect will seek out that reference and return the contents of (B20, E12, L60, etc.) regardless if its a word or number.