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.
Bookmarks