hunna
11-18-2011, 10:56 AM
Hi all, I have a fomular that matches the data in certain range (in the code is "W17") to another (in the code is $S$12:$S$3054 ) with some error.
The error is determined in "$AP$35".
=(INDEX($S$12:$S$3054,MATCH(1,INDEX(($S$12:$S$3054>=W17-$AP$35)*($S$12:$S$3054<=W17+$AP$35),0),0)))
My problem is I want to match the data that is not in the same area (I am not sure how to call it), for example
=(INDEX($S$12:$S$3054, $T$12:$T$3054,MATCH(1,INDEX(($S$12:$S$3054, $T$12:$T$3054>=W17-$AP$35)*($S$12:$S$3054, $T$12:$T$3054<=W17+$AP$35),0),0)))
In the example I want to match "W17" (with the error in $AP$35) to $S$12:$S$3054 and $T$12:$T$3054
but the code is not working, so can anybody help me for this?
Any help would be appreciated.
The error is determined in "$AP$35".
=(INDEX($S$12:$S$3054,MATCH(1,INDEX(($S$12:$S$3054>=W17-$AP$35)*($S$12:$S$3054<=W17+$AP$35),0),0)))
My problem is I want to match the data that is not in the same area (I am not sure how to call it), for example
=(INDEX($S$12:$S$3054, $T$12:$T$3054,MATCH(1,INDEX(($S$12:$S$3054, $T$12:$T$3054>=W17-$AP$35)*($S$12:$S$3054, $T$12:$T$3054<=W17+$AP$35),0),0)))
In the example I want to match "W17" (with the error in $AP$35) to $S$12:$S$3054 and $T$12:$T$3054
but the code is not working, so can anybody help me for this?
Any help would be appreciated.