List of Codes and Display Names for Codes

[hoganc]

Hi all,

I am trying to find out if there is something I can do to save m
physically switching screens and finding out the names of a a code.

Ie I have a list of telephone no.s on a work sheet and each no. belong
to a team somtimes teams have more than one phone no. as expected.

I also have a list of all the phone calls made out of a buidling and
need to find out which team is making the most amount of calls etc. S
I go to the no. screen and ctrl and F and type in the no. find the tea
flick back to the no.s screen and type in next to it?

Has anyone any ideas??? Help please this takes me two days a week. :

 

[JE McGimpsey]

One way:

Assume the numbers are in Sheet2, column A and the team name is in
Sheet2, column B. Further assume the numbers you're looking up are in
sheet1, column A. Then in an empty column in Sheet1 (say, column D),
enter:

D1: =VLOOKUP(A1,Sheet2!A:B,2,FALSE)

and copy down as far as necessary.