| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)) -- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)) -- |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)) -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a calendar and put lines in it as space holders | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| backwards find function to find character in a string of text | Excel Programming | |||
![yusuf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
