This is probably something very simple but I can't get vlookup to
actually lookup....

i'l explain more clearly.

I have a bunch of staff codes on a goals form, these come in the format
of ME00 ###013.

i am trying to get vlookup to bring up when these staff members are
rota'd to work but on the rota file they are listed simply by the three
digit code.

I have managed to sort it so that I have just the three digits by using
MID but vlookup will not look this three digit number up! it will only
look it up if i actually type in the code which is no good as i need
this to be as automated as possible.

any help apreciated!


--
hobo jojo
------------------------------------------------------------------------
hobo jojo's Profile: http://www.excelforum.com/member.php...o&userid=28459
View this thread: http://www.excelforum.com/showthread...hreadid=480590