Can something like this be accomplished?
I have a workbook with two sheets.
Sheet 2 has data like:
pt R5 R6 R7 R8 R9
010 76.0 58.1 51.3 45.8 37.5
020 81.9 61.9 54.7 49.3 44.1
030 95.0 90.0 87.5 85.0 82.9
040 70.2 57.3 51.0 45.8 41.6
etc....................
Sheet 1 contains for example a pt of 020 and a factor of 60.0. Is there
anyway to pull the R value the would be either , < or = the factor in the
row of 020? Say for example the factor of 60.0 in this case would return a R
value of "<R6".
TIA
--
kr
|