Mod. edit: below originally posted on thread: http://www.excelforum.com/excel-gene...ml#post2553091
sir,
i have to display from matched cell it must display -1 row -2,-1,0,1,2 columns cells for example
8419 8428 8838 9288 9691
8262 8136 8660 8987 9603
8516 8558 8672 9212 9647
8656 8624 8875 9317 9687
8361 8365 8625 9028 9083
8414 8440 8798 8697 8864
8202 8500 8539 8667 9062
7367 7631 7771 8117 8287
7771 is matched cell results must be
8202 8500 8539 8667 9062
please provide me formula
Bookmarks