Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
=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? |
#4
|
|||
|
|||
=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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|