Help Searching for a match that returns same text

[Eggplant2016]

I want to enter text in a cell and then if the text that i enter matches text found in a cell that is part of a list, then I want the next 2 columns over to populate with numbers that correspond to the matched text.

So A1 is "Blue". B1 is "10" and C1 is "50".
A2 is "Red", B2 is "15", and C2 is "40"
A3 is "Green", B3 is "20" and C3 is "60"

So i want to enter "blue" in A6 and have B6 and C6 populate with the values from B1 and C1 respectively.

If i enter "Green" into A6, i want B6 and C6 to populate with the values from B3 and C3.

But I want this original list of colours to include hundreds of options. Each with their own values in the adjacent columns.

Thank you for your help

 

[Fluff]

Hi & welcome to MrExcel
Something like

Excel 2013/2016
	A	B	C	D	E	F	G
2	Blue	10	50		red	15	40
3	Red	15	40
4	Green	20	60
report

Cell Formulas
Range	Formula
F2	=INDEX(B$2:B$4,MATCH($E2,$A$2:$A$4,0))
G2	=INDEX(C$2:C$4,MATCH($E2,$A$2:$A$4,0))

 

[Eggplant2016]

Thats exactly it! Thanks so much!!

 

[Eggplant2016]

Is there a way to also add 1000 to the total in F2, if there is a "1" in "H2", 200 if a 2, 3000 if a 3 etc?

 

[Fluff]

Try
=INDEX(B$2:B$4,MATCH($E2,$A$2:$A$4,0))+H2*1000

 

[Eggplant2016]

Thats great , thank you.
Now I want to have multiple "blues and greens" etc in Column A and have column "F" not only match the first instance, but total all the corresponding figures in "B" that are next to a "blue" or whatever color.

 

[Fluff]

I would suggest that you start a new thread & explain EXACTLY what you want, rather than continually "moving the goalposts"

 

[Eggplant2016]

Ok will do, thanks