+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    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

    Code:
    =INDEX($AJ$226:$AK$1833,MATCH($C7,$AK$226:$AK$1833,),MATCH("payerref",$AJ$226:$AK$226,))
    Any help with this would be great.. Im not too hot with excel and been stuck with this for ages

  2. #2
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,155
    Thank Post
    131
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    County filter has blocked the images, could you host them elsewhere?

    EDIT: there working now.

  3. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    seems I was over-complicating myself.

    Code:
    =VLOOKUP($C7,$AJ$226:$AK$1833,2,FALSE)
    thats all I needed hah.

  4. #4

    Join Date
    Jan 2007
    Location
    Birmingham
    Posts
    807
    Thank Post
    29
    Thanked 36 Times in 24 Posts
    Rep Power
    27
    Would vlookup not be easier to use in this situation?

    Edit:
    Oops too slow, yes you had over complicated it! :-)



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 07:18 AM
  2. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 05:55 PM
  3. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 12:23 PM
  4. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 11:08 PM
  5. Bizzare Excel Problem
    By Norphy in forum Windows
    Replies: 3
    Last Post: 17th January 2006, 11:19 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •