what function should I use

[pilgrim]

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

 

[Billy Liddel]

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]

Thanks Billy Liddel, once I had relalised i need to put in a range it woorked
perfect
many many thanks
Pilgrim

 

[Billy Liddel]

You're welcome

Thanks for the rating and reply

Regards
Peter

 

[Prasadkakarla]

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