Hi,

I have the following problem:

on sheet1 i have cells A20:A30 filled with stuff like

18-20
20-25
25-30
etc
furthermore i have two variables var1 and var2 which are both numbers

on sheet2 i have a matrix in the range ("A4:CS53")
in colmn on i have a list of numers ranging from 1 to 65

I would like to do the following
1. take the first 2 characters in A20, sheet1 and look his number up in the
first column of the matrix (sheet2) to determine the row and then..
2. i need column number -58 + var1 + var2 to lookup the cell i need and
return this value
3. i need to put this value onsheet1 in cell "C20"
3. I need to have the same thing done for the cells A21 through A30 on sheet1

Please help me with the code tot do this !
Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200509/1