IF AND FORMULA WITH CONDITION

[furqan_q]

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 . Thanks

 

[jasonb75]

Best way would be to have a separate column with "3rd partybrand" "arcbrand" etc, then the relevant "P-", "A-", etc in the next column, then use vlookup to get the results.
Where 'table' refers to the list described above, the formula would be something like this.

=VLOOKUP(B2&C2,table,2,0)&D2