HELP!!! Need to know how to reference

[mhearn]

I have a range of technician #s in one column, followed by the Technician Names in the column next to it.

I will hide this "index" when I have my function set up, but it is where I will get the info from.

I want to simply set up 2 columns in which one will consist of the Technician's # and the other will be the name.

I need to set up a function for column B (the Name Field).
I need to make it so when the tech # is entered in column A, the corresponding name is automatically entered in column B.

Which function should I use...

Thanks!!!!

Franklin

[SteveG]

Franklin,

If your tech names are in sequential order 1-any. You can use a the choose function.

=IF(C2>0,CHOOSE(C2,$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$B$8,$B$9))

Where C2 is the Tech # you are inputting and b2:B9 are the corresponding tech name index. My hidden index was:
A B
Tech # Tech Name
1 John
2 Steve
3 Bill
4 John
5 Jim
6 Hank
7 Bill
8 Ted


Resulted in this when the number in column C was entered manually and the formula above resides in column D.

C D
Tech # Tech Name
1 John
2 Steve
3 Bill
4 John
5 Jim
6 Hank
7 Bill
8 Ted


Hope this helps.

Steve