how to define dictionary to access by key?

Hello
I have no idea how to solve my problem.
I have dictionary defined as series of keys and let's say two values:
name1,val1A,val1B
name2,val2A,val2B
...and so on

I would like to define named range from "name" column allowing user to select desired name from combo on another sheet.
This is easy

But after that I would like to get val1 and val2 for selected name and show them with some calculation;
For example to construct two columns like this:
<nameX_selected_from_combo>, (<val1X>+<val2X>)/2

All the problem is how to select values from the same row as name selected in range.
Anybody can help?

Best regards for all.

VLOOKUP() !
Many thanks. That is exactly what I need