Thread: Refrencing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Refrencing

If A1 contains the string "A5" and you want to display or use the value in
A5 in another cell, then in the other cell, put in the formula

=Indirect(A1)

--
Regards,
Tom Ogilvy


"John Smith" wrote in message
...
Don Guillett wrote:
Have a look at the MATCH worksheet function



This is promising...
And how could I do referencing on field when I now that is "A5"?