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,
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.