Find cell in 2nd array using row and column from the first array Excel 2010 VBA

Find cell in 2nd array using row and column from the first array

I am having trouble getting data from 2 sources using VBA.

See the linked worksheet for the data I am querying.

I have a userform that has the ranks_textbox with "7 _ 6" in it.
I use that value to determine the row in rank_v_rank it resides in. (row 3 in the example)

Another textbox on the form has the score_textbox with "5 _ 3" in it.
I then need to find column in that row that the value of the score_textbox has. (col F in the example)

What I can't seem to figure out how to get.. is the data for the points_textbox.
That would be the "2 _ 1" in row 3 col Q.

I am doing this programmatically in Excel 2010 VBA.


Example;

ranks_textbox.value = "7 _ 6"
Score_combobox.value = "5 _ 3"
I need to get "2 _ 1" from poss_scores into the points_textbox

The following are the involved named ranges.

rank_v_rank =Data!$G$2:$G$43
poss_scores =Data!$I$2:$R$43
poss_points =Data!$t$2:$AC$43
link to workbook example; https://www.dropbox.com/s/9gqh7f3fa5...ook1.xlsx?dl=0

You da MAN ! ! !
minor changes to use by vars and all working perfect.
Many thanks..