Hi

It sounds as though you need to convert your extracted value from MID into
numeric to compare with the vlookup table.

=--MID(A1,9,3)
or
=--(RIGHT(A1,3)

Regards

Roger Govier


hobo jojo wrote:
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!