Forum Discussion
Excel using fixed cell value to add to row number in formulas
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
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.
