Sean

=IF(OR(D1=1,D1=4),B2,C2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Sean" wrote in message
...
I am stuck, I need a formular that will give me a telephone no, depending
on
a type
1-4
Colum A = Ref No
B = Old Tel No
C = New Tel No
D = Type

If Type 1 & 4 = Keep existing no
If Type 2 & 3 = Will use New Tel No

Can anyone help