Hi,

I can get the value of a field from with the function
=CONCATENATE("$M","$"&VALUE(MONTH(A6)))

Result is $M$8

However if I try to add this to another function
=((B6*$B$2)/365)*CONCATENATE("$M","$"&VALUE(MONTH(A6)))

I get the error #VALUE!

If I type
=((B6*$B$2)/365)*$M$8
Then I get the correct results.

I cannot find a solution in Excel Help, so I thought I'd visit the experts

Cheers
Craig.

Try:

=indirect("M"&MONTH(A6))





"Craig & Co." wrote:

Hi,

I can get the value of a field from with the function
=CONCATENATE("$M","$"&VALUE(MONTH(A6)))

Result is $M$8

However if I try to add this to another function
=((B6*$B$2)/365)*CONCATENATE("$M","$"&VALUE(MONTH(A6)))

I get the error #VALUE!

If I type
=((B6*$B$2)/365)*$M$8
Then I get the correct results.

I cannot find a solution in Excel Help, so I thought I'd visit the experts

Cheers
Craig.

--

Dave Peterson

Perfect!!!!!

Thank you!!
Craig.

"Dave Peterson" wrote in message
...
Try:

=indirect("M"&MONTH(A6))





"Craig & Co." wrote:

Hi,

I can get the value of a field from with the function
=CONCATENATE("$M","$"&VALUE(MONTH(A6)))

Result is $M$8

However if I try to add this to another function
=((B6*$B$2)/365)*CONCATENATE("$M","$"&VALUE(MONTH(A6)))

I get the error #VALUE!

If I type
=((B6*$B$2)/365)*$M$8
Then I get the correct results.

I cannot find a solution in Excel Help, so I thought I'd visit the
experts

Cheers
Craig.

--

Dave Peterson