excel lookup problem, can someone help me please?
Trying to do a lookup, and it is kind of working.
Basically got a list of pupil codes, and a number of different pupil codes correspond to a single other code.
stashed away in the sheet is another couple of rows which Im looking up:
Its working for the first lookup, but for the other two, it isnt working.. Can anybody spot what I have done wrong?
the formula I used is
Any help with this would be great.. Im not too hot with excel and been stuck with this for ages