Hi,

I have a problem finding data in a matrix.

I have a cell that is filled with stuff like "18 - 20"
I have a matrix on another sheet in the range
worksheets("staffels").range("A4:CS53")
Now i would like to do the following:

take the first two items ("18") of the cell minus the number 14 and look
this ip in column 1 of the matrix and then i need the result from column
number -58 + var1 + var2

Does anybody have a hint how to do this in VBA ?
Thanks,
Pierre