find holders name

[yusuf]

Hi

XP. New to excel programming. How can I reach person 2 automatically
when I put ticket number 33 on sales sheet ? .Log table as below.

startno endno salesperson
1 15 person 1
16 35 person 2

Thank you very much in advance .

 

[Tom Ogilvy]

If you put 35 in A1 (rather than 33), you could retrieve that value with

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

 

[yusuf]

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]

Will the numbers be sequential as you show?

 

[yusuf]

Not necessarly. But i can sort it if needed.

Kind regards / yusuf