Hi Guys,

I'm back!

I have an problem in that I want to calculate the following:

If Summary!D3 = 3 then NewSheet! A5 = Summary! R3
But
If Summary!D3 = 2 then NewSheet!A5 = Summary! S3
or
If Summary !D3 = 1 then NewSheet!A5 = Summary T3
else ""

In essence I want a formula or Macro that will display a result in a new
sheet which is dependent upon the value of cell D3.

This needs to be repeatable as I will have 18 times I will need to calculate
this (i.e D3, E3, F3 etc)

Thanks

Terry