A couple of questions about your data...

Is each line in a single cell (that is, is CJ03304442 872620080 16 VI SV in
cell A2)? Or are these spread into different cell in the row (that is, does
A2 contain CJ03304442 and B2 contain 872620080, etc.)?

Also, what do you mean by "I know this line"? In what way do you know it? Is
the value or values (depending on how you answered the above question) in a
cell or cells somewhere else on your worksheet?

Where do you want the "answers" to be located at?

Can there be more than one match for the data that you know? If so, how is
that to be handled?

--
Rick (MVP - Excel)


"AND" wrote in message
...
hello,
I have these data:
LVSNR AKNUS AKAVZ LVCOD LVARR
CJ03304442 872620080 16 VI SV
CJ03304442 872620080 41 VI SV
CJ03304442 872620080 41 VI SV
IU00789017 873050400 16 BZ MI11
IU00789017 873050400 16 BZ CO
MT21880207 872465980 07 MEL CZ
MT21880207 872465980 05 MEL MO
MT21880239 872466300 16 MEL CZ
MT21880239 872466300 16 MEL CZ

they are thousands rows, so I don't need of filter on, becouse they are
too
much to be check one to one.

I need know
1.what's the line next a value. AND
2.what's the line before a value.
for example:
If I know this line:
IU00789017 873050400 16 BZ CO
1. I need to know the next line, tha's:
MT21880207 872465980 07 MEL CZ

and if I know this line:
MT21880239 872466300 16 MEL CZ
2. if I need to know the previous line, what's the
way?:
MT21880207 872465980 07 MEL CZ

I know it is not easy, but I hope u can help me, becouse it's really
important for my job!.
thanks a lot to everyone wants help me.
--
Andrew