R Rebeca New Member Jul 10, 2016 #1 if Cell A1 begins with Pla and Cell Bi starts with T then show trailer, but if b1 starts with xx then show warehouse
if Cell A1 begins with Pla and Cell Bi starts with T then show trailer, but if b1 starts with xx then show warehouse
N NARAYANK991 Excel Ninja Jul 10, 2016 #2 Hi , It would help if you uploaded a file with more data. Going by what you have posted , the following formula should work : =IF(LEFT(A1,3) = "PLA" , IF(LEFT(B1) = "T" , "Trailer" , "Warehouse") , "Not Known") Narayan
Hi , It would help if you uploaded a file with more data. Going by what you have posted , the following formula should work : =IF(LEFT(A1,3) = "PLA" , IF(LEFT(B1) = "T" , "Trailer" , "Warehouse") , "Not Known") Narayan
