| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what function should I use
I am looking to inseert a Question into my excell sheet which will require
another cell to give an answer ie enter tom and the other cell will show sales person. should I use a function or how do I do it regards pilgrim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what function should I use
Hi
The easiest way is VLOOKUP. Create a table of sales persons (this can be on another sheet and name it SalesTeam. e.g Ref Sales Person Jne Jane Willoughby Jon John Slazinger Ptr Peter Atherton Tom Tomas Radzinski Note: the Ref list must be sorted. in the other cell use the formula =VLOOKUP(A2,SalesTeam,2,0) where A2 is the cell you type your reference. Regards Peter "pilgrim" wrote: I am looking to inseert a Question into my excell sheet which will require another cell to give an answer ie enter tom and the other cell will show sales person. should I use a function or how do I do it regards pilgrim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what function should I use
Thanks Billy Liddel, once I had relalised i need to put in a range it woorked
perfect many many thanks Pilgrim "pilgrim" wrote: I am looking to inseert a Question into my excell sheet which will require another cell to give an answer ie enter tom and the other cell will show sales person. should I use a function or how do I do it regards pilgrim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what function should I use
You're welcome
Thanks for the rating and reply Regards Peter "pilgrim" wrote: Thanks Billy Liddel, once I had relalised i need to put in a range it woorked perfect many many thanks Pilgrim "pilgrim" wrote: I am looking to inseert a Question into my excell sheet which will require another cell to give an answer ie enter tom and the other cell will show sales person. should I use a function or how do I do it regards pilgrim |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what function should I use
In this situation VLOOKUP is the useful function
first of all u prepare a data like u r questions and the answer e.g tom : sales person name then u give the link =vlookup(question cell(A1),Table array (select the data table), 2 (answer column),false (it will check the match) u r req question answer will be come in second cell try this take care bye -- Name : K.Prasad Inventory Manager CRYSTALGALLERY DUBAI "pilgrim" wrote: I am looking to inseert a Question into my excell sheet which will require another cell to give an answer ie enter tom and the other cell will show sales person. should I use a function or how do I do it regards pilgrim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
