Thread: A1+B(C1)
View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

Try this:

=A1+INDIRECT("B"&C1)

Does that help?
--
Regards,
Ron


"jbwerner" wrote:

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?