It's in my response. The formula I posted has the extraneous parentheses
removed.

Regards,
Fred.

"Tel" wrote in message
...
Hi Fred,

Many thanks for your response. to be honest I was pretty damn pleased
with
myself that I'd worked it out this far.

To be honest the user has no control over the content of D3 so it
shouldn't
be an issue. However, in the interests of completeness I take your
comment
on board, could you advise which set of parentheses are extraneous please.

Many thanks

Tel

"Fred Smith" wrote:

What happens if d3 doesn't equal any of the cells listed? With your
formula,
you will get FALSE returned. Perhaps you want (extraneous parentheses
also
removed):
=IF($D$3=AG2,AG3,IF($D$3=AH2,AH3,IF($D$3=AI2,AI3,I F($D$3=AJ2,AJ3,""))))

Regards, Fred

"Tel" wrote in message
...
I've found the answer:

For the benefit of others here it is:

=IF($D$3=AG2,AG3,(IF($D$3=AH2,AH3,(IF($D$3=AI2,AI3 ,(IF($D$3=AJ2,"")))))))

Now all I need is help to write a macro that will copy all the text in
Cells
AD1:AD34 and paste it as values into column C of a new workbook then
remove
the blank lines in the new workbook and saving it with a specific
filename
sourced from 2 cells in the current workbook.

"Tel" wrote:

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