Multiple @if statements

[leebo1973]

morning all

I have the following data set:

Name Date Start PostCode EndPostcode

I have sorted the data by Name and Date

I want to be able to say that if the Name is the same as the Previous Record, and the Date is the same as the previosu record, then the Start PostCode is the End Postcode from the previosu record. If not then then the StartPostcode applies

Thanks

 

[Mile-O]

=if(and(b2=b1,a2=a1),d1,c1)