Would be grateful for some more help..... yesterday I was trying t
find out if there is something I can do to save me physically switchin
screens in excel and finding out the names of a dept attached to 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?

I used this as an example

E C803/2297 only thing is the code looks like and it actually look
like

C803/C803/2297 this

the code i was given did work but only if both codes resemble the firs
example

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

I need to be able to paste a formula next to the code E codes and i
display the name of the releavent dept????

E C803/2297  

C803/C803/2297 *and then  the name of the dept *

Welfare South Division Parklands is displayed on the right

The code needs to take into account the last 8 digits because the C80
relates to a builiding and we can have two extentions the same in
building