Cell to return corresponding text

[Goddess]

Hi, I have a table, where I need the cell to return the corresponding text based on the text I entered in another cell. However, the reference cell, in this example "car"& "van" are grouped as "others" in the data table.

I basically need the data in the yellow cells, B2:D3 to auto populate when I enter the data in cell B1:D1. Bus will have it's own unique colour code, whereas the rest of the vehicles will be grouped as "others" as they have the same colour code. Possible to do it?

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		car	van	bus					Others	Bus
2		Blue	Blue	Blue-light					Blue	Blue-light
3		Green	Green	Green-dark					Green	Green-dark
4
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=I2
C2:D3	C2	=I2

Thanks!
Irene

 

[Burrgogi]

Thanks for the explanation @Eric W