Help this is wrecking my head!!

  • Thread starter Thread starter hoganc
  • Start date Start date
H

hoganc

:eek: Hi again,

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
 
Back
Top