View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default functions derived from cell contents

Try this:

=INDIRECT(A1&A2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" 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

X-posted to microsoft.public.excel.programming