ExcelBanter - formulas derived from cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formulas derived from cells (https://www.excelbanter.com/excel-programming/372830-formulas-derived-cells.html)

[email protected]

formulas derived from cells

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

Die_Another_Day

formulas derived from cells

=INDIRECT(A1&A2)

Charles Chickering

wrote:
Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

Gord Dibben

formulas derived from cells

=INDIRECT(A1&A2)

Gord Dibben MS Excel MVP

On 13 Sep 2006 13:22:22 -0700, wrote:

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

All times are GMT +1. The time now is 08:32 AM.