Hi Narayan,
Sorry due to some format issue, the display is not proper.
Column A contains values like Val1, Val2, Val3 and so on. (Note that these for sample purpose).
Cell B1 contain a number which would be referred in Indirect formula in Column C.
I hope it is clear now.
Regards...
Hi All,
I needed your help to solve my problem.
I have 3 columns:
A B C
1 Val1 1 =Indirect("A"&$B$1)
2 Val2
3 Val3
Now I want Val2 in C2, Val3 in C3 and so on. So that means, I want the value in B1 to be incremented by 1 on every cell.
Please help me to...