Can you suggest a formula which would populate the data says If A2 contains "Apple", returns "Apple" else "Huawei" or "Nokia".
Note that the location of the brand, Capacity, Year and Model may not be arranged in that order.

Excel.JPG