A
AK
I have a need to define cell A1 like so :
=CONCATENATE("System Name: ",D2," ",D3)
but instead of a fixed D2 & D3, I would like to replace it with E2 & E3 if I
click on column E, F2 & F3 if I click on column F, etc... i.e. cell value
will be dependent on which column I click on.
Is there a way to do this ?
Thanks,
ak
=CONCATENATE("System Name: ",D2," ",D3)
but instead of a fixed D2 & D3, I would like to replace it with E2 & E3 if I
click on column E, F2 & F3 if I click on column F, etc... i.e. cell value
will be dependent on which column I click on.
Is there a way to do this ?
Thanks,
ak