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