If two cells contain certain text

[WCE_123]

Hi,

I would like to look at cell -

a1 this will contain - 'Double Pg Input' or 'Single Pg Input' (txt)

b1 will contain - 'Pg1' or 'Pg2' or 'Pg3' or 'Pg4' (txt)

If a1 contains 'Double Pg Input' & b1 contains 'Pg1' then I would like c1 to show 'D1'

If a1 contains 'Single Pg Input' & b1 contains 'Pg1' then I would like c1 to show 'S1'

If a1 contains 'Double Pg Input' & b1 contains 'Pg2' then I would like c1 to show 'D2'

If a1 contains 'Single Pg Input' & b1 contains 'Pg2' then I would like c1 to show 'S2'

And so on.

Hope you can help

Cheers

WCE

[etaf]

what happens with Pg3 & Pg4

=IF(AND(A1="Double Pg Input",B1="Pg1"),"D1",IF(AND(A1="Double Pg Input",B1="Pg2"),"D2",IF(AND(A1="Single Pg Input",B1="Pg1"),"S1",IF(AND(A1="Single Pg Input",B1="Pg2"),"S2","Not Valid"))))

[haripopuri]

=left(a1,1)&right(b1,1)

[etaf]

haripopuri wow - missed that, looked at it a few times, and was sure we i could simplify - but thats cool

added to your rep