Windows Thread, excel lookup problem, can someone help me please? in Technical; Trying to do a lookup, and it is kind of working.
Basically got a list of pupil codes, and a ...
2nd July 2008, 01:32 PM #1
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
IDG Tech News
2nd July 2008, 01:36 PM #2
County filter has blocked the images, could you host them elsewhere?
EDIT: there working now.
2nd July 2008, 01:48 PM #3
seems I was over-complicating myself.
thats all I needed hah.
2nd July 2008, 01:51 PM #4
Would vlookup not be easier to use in this situation?
Oops too slow, yes you had over complicated it! :-)
By sqdge in forum Office Software
Last Post: 10th February 2013, 07:18 AM
Last Post: 14th July 2011, 05:55 PM
By wesleyw in forum How do you do....it?
Last Post: 29th August 2009, 12:23 PM
By TechSupp in forum General Chat
Last Post: 2nd November 2007, 11:08 PM
By Norphy in forum Windows
Last Post: 17th January 2006, 11:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)