HI, i need one formula covering all conditions, if in b2 is "3rd party" and c2 is "brand" then result should be "P-12000 AND if i change b2 with "arc" and c2 with "office" then result should be "OF-12000" and so on, but all from b2 to b8 i need condition in one formula .I attached the jpeg file...