Thread: A1+B(C1)
View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

=A1+INDIRECT("B"&C1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jbwerner" wrote in message
...
I want to add A1 to B?. C1 contains a match formula that returns the row
number. I want to add A1 to B(C1). How do I write this formula?