Until you post some sample data that is truly representative of what you need a solution for, I'm not doing any more with this. You also need to explain whether, for example, the value you're looking for is always a certain number of rows above or below the matched value (eg 1 row above or 4 rows below) and how one can be sure that whatever's found there isn't something else.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]