Hello, I work on a help desk in a call center and we have a nifty
worksheet where we can select the agent who calls us from a drop-down
list. The problem is, we also have to select the supervisor from
another drop-down list. I have been doing research on how to stream
line this process by having the supervisor's name automatically
displayed when we select the the agent's name from the drop-down list.
Unfortunately, the guy who designed this worksheet no longer is with the
company. I have already modified it to give statistics on the reps who
call, but i'm trying to stream line the entering process. I know how
to make drop-down lists and everything, but i'm having trouble with the
returning value part. After some research, it looks like the VLOOKUP
function will be the best bet, but i don't understand all of the
arguments you have to enter. My data looks like the following:

Worksheets: Entered!, Data!

on Data!:
A B
AgentName1 Supervisor1
AgentName2 Supervisor2
AgentName3 Supervisor1
AgentName4 Supervisor3 etc.

on Entered!, I want the following to happen:
A B
(when select) AgentName1 (want it to return) Supervisor1
(when select) AgentName4 (want it to return) Supervisor3 etc.

From what I have found, the formula needs to look something like this:
On Entered!:
A B
=VLOOKUP(A1, Data!A1:B1, 2, false)

i'm sure you know why i'm getting the #NA error returned instead.

I don't understand what the 2 or the false does and that might be the
problem, though i'm sure it also has something to do with my cell
references. Does anyone have any idea on how to get this to work?

My second question is how do you get a default value to be displayed
until you make a selection from the drop down list? The way I have my
new sheet setup, it's blank until you make a selection. Any and all
help will be greatly appreciated!!

Thanks!

Curiously yours,
Andrew


--
Budamon