|Your question is not clear. Let's look at a few items:|
"If cells B2:34 contains a match of data in cell B37"
You are asking about matching multiple cells to a single cell. Do you mean if any cell in B2:B34 matches the contents of B37 or if every cell in B2:B34 matches the contents of B37 or do you mean something else?
"I need cell K37 to track costs specified in cells J2:J34"
Once again, you mention a single cell vs. a range of cells. What do you mean by "track costs specified in cells J2:J34"? e.g. the SUM of the cells?
"replacing B37 with C37 and so on"
"and so on" is not something we can really work with. What exactly do mean by "and so on"?
Keep in mind that we cannot see your spreadsheet from where we are sitting, so you need to provide enough detail for us to be able to understand what you have and what you want.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.