Prev: Last number in a column shows in the total/summay line cell
Next: How to sort duplicates?
From: Malters on 22 Mar 2010 21:45
For example, to acquire the cell reference 'c5' the C is generated by a
formula in one cell, and the 5 is generated in a different cell
From: T. Valko on 22 Mar 2010 22:09
Try this...

A1 = C
B1 = 5

=INDIRECT(A1&B1)

Which evaluates to =$C$5

--
Biff
Microsoft Excel MVP


"Malters" <Malters(a)discussions.microsoft.com> wrote in message
news:F8BDB88A-7371-4C02-8973-B7E8F3E5E50D(a)microsoft.com...
> For example, to acquire the cell reference 'c5' the C is generated by a
> formula in one cell, and the 5 is generated in a different cell


 | 
Pages: 1
Prev: Last number in a column shows in the total/summay line cell
Next: How to sort duplicates?