A1+B(C1)

[Guest]

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?

 

[Guest]

Try this:

=A1+INDIRECT("B"&C1)

Does that help?

 

[Guest]

=A1+indirect("B"&C1)

 

[Bob Phillips]

=A1+INDIRECT("B"&C1)

--

HTH

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

 

[Guest]

Yes, indirect is what I was looking for.

Thanks

Try this:

=A1+INDIRECT("B"&C1)

Does that help?

 

[Niek Otten]

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