Consulting

Results 1 to 7 of 7

Thread: Lookup problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jul 2009
    Posts
    7
    Location

    Unhappy Lookup problem

    I have the following which I would like to do, but cant seem to get it right.


    Col A ******Col B ******Col C *******Col D

    John ********KZN ********1 ************2
    Walt *********MP ********3 ************1
    Joe **********GN ********2 *************2
    Joe **********KZN *******1 *************1

    (excuse asterisks, but couldnt get the items lined up under the columns )



    I would like to lookup an item in col A (say “Joe”) and col B (say “KZN”) – this equates
    to the last row of data. However once this is “matched” I want the answer to concatenate the corresponding items
    in col C and D. Hence my answer s/be 11.

    I have tried to use SUMPRODUCT to return a value of “1” when it matches in col A and B, and then to return the corresponding
    col C and D as the answer, but cant get that right.
    There is probably an easier way for the boffins but I’m struggling.
    Thankx
    Last edited by Bazza; 09-29-2009 at 03:44 AM.

Posting Permissions

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