find holders name
 

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 .

find holders name
 

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

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

--
Regards,
Tom Ogilvy

"yusuf" wrote in message
m...
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 .

find holders name
 

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))

--

find holders name
 

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))

--

find holders name
 

Not necessarly. But i can sort it if needed.

Kind regards / yusuf



"Tom Ogilvy" wrote in message ...
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))

--