A1+B(C1)

J

jbwerner

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

Bob Phillips

=A1+INDIRECT("B"&C1)

--

HTH

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

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
 
Top