vlookup to extra mutliple lines from spreadsheet RRS feed

  • Question

  • Hi,

    I'm hoping you can help me with the below issue. I've tried searching the internet, but cant find anything.

    I have 3 spreadsheets - spreadsheet 1, 2 and 3.

    spreadsheet 1 = is a list of all the data with all the columns

    spreadsheet 2= list of all the 'names' that we need to search in s/s 1 (A1, A2, A3 etc)

    spreadsheet 3 = the output file

    'Name' is the primary key and is common in both spreadsheet 1 and 2.

    I need to perform the following:

    - Based of s/s 2, I need to search for the name in s/s 1.

    - If it is found, I need to return the value of column H and J into the output file (s/s 3)

    - The issue is, the 'name' can be found more than once in s/s1.

    If this is the case, I need to return them values into s/s 3 as a new line (under the previous information).

    - I then need this process to carry on for the next 'name' in s/s 2 and carry on.

    I hope all this makes sense. I really appreciate all your help.



    Thursday, October 3, 2013 8:35 AM


  • If the data is in A1:A100 and the vLookup finds the item in A10 then repeat the search in A11:A100.
    Put the search inside a loop that repeats until the return value errors.
    (You can use Match instead of vLookup as all you need is the row position)
    Jim Cone
    Portland, Oregon USA
    Extras for XL add-in (classic menubar, 8 functions &...) (Dropbox)

    • Marked as answer by Chaz1010 Tuesday, October 8, 2013 11:17 AM
    • Edited by James Cone Tuesday, October 18, 2016 4:53 PM
    Thursday, October 3, 2013 10:41 AM