In most cases I can work my way around formula (VBA I have to ask for help) but I have a requirement that is causing me a problem.

If a user selects "Individual CPC – Please complete on Summary" from a data validated cell (D46) of sheet 1, then cell T31 of sheet 2 should accept a number ONLY, however if D46 on sheet one does not equal "Individual CPC – Please complete on Summary" than cell C55 of sheet 1 should be returned.

many thanks in advance