Thread: formulas derived from cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default 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

Reply With QuoteReply With Quote