SUMIF where sum_range consists of text strings?

Hi,

I have a worksheet where I want users to choose a value from a validated list, and based on their chosen value I want to collect various text strings from other parts of the sheet, and present it to the user. Normally I would use SUMIF, but the sum_range in my sheet is text, so it doesn't work.

Let's say the user selects a value in the first cell (A1=Train). Based on that I want to find that selection in B1:B3 (Bike, Train, Plane) and give the corresponding value from C1:C3, where these values are text (Cheap, Efficient, Fast), and present the result in, say, cell A2, so that A2=Efficient.

Is there another function that works for this?

Any help would be appreciated!

Use VLOOKUP()