Will the numbers be sequential as you show?

--
Regards,
Tom Ogilvy


"yusuf" wrote in message
om...
Thank you Tom.

I think I failed to detail my trouble.
ticket number 33 should be searched between start no and end no of the
ticket
books that are given to sales person.I mean all ticket books are logged
with
their start and end numbers.

Kind regards


"Tom Ogilvy" wrote in message
...
If you put 35 in A1 (rather than 33), you could retrieve that value with

=if(a1="","",vlookup(A1,Sales!A1:B200,2,False))

--