A1+B(C1)
 

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?

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?

=A1+indirect("B"&C1)

"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?

=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?

Yes, indirect is what I was looking for.

Thanks

"Ron Coderre" wrote:

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?

But make sure the MATCH() really returns the row number, not the relative
row number in the table (if the table does not start at row 1). If the
latter is the case, add the starting row-1

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Bob Phillips" wrote in message
...
=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?