Excel using fixed cell value to add to row number in formulas

Copper Contributor

Hello! I am looking for a way to add a fixed cell value e.g. 3 from cell C21 to the actual row number in a formula. (In a very wrong way e.g A(26+$C$21). How can that be done?

 

Thanks in advance,

1 Reply

@Carlos8765 

 

Hi Carlos

I'm not sure if this will help, but it sounds like you should look up the INDEX/MATCH function. If not, I'm sure you will find it useful in other ways, maybe later on. It returns row numbers.