Hello,
I have a 3 lists, one for the data values, whereas other raw data.

Data values-
A1,A2,A3, - (structure)
Red,34,10
Blue,12,52
Green,15,72
Yellow,12,162


Raw Data,
A1,A2,A3
Red
Red
Red
Red
Blue
Red
Green
Yellow
Yellow
Red

Now i want that if cell has "red" in it, then A2 is inserted 34, wheres A3, 10.
I have about 12K entries, and about 300 colors in data values, so pls help as doing it manually... will not be feasible.

I am familiar with running macros, and also with = functions. Any help will be greatly appreciated, Thanks.