how do i turn column letters to numbers and vice versa

------------------

take y values from column and take x values from row

I have 'resolved' values in column A1:A10
I have 'received' values in row B11:K11

I need to fill out a table using the tables axis values stored in the column and row above.

Such as:

 For i = 1 to 10 Step 1
  Resolved = Range("A" & i).Value
 For j = B to K Step 1
  Received = Range(j & 11).Value

 Range(j & i).Value = 2*(Resolved+Received)/3

 Next j
 Next i