none
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.

    Thanks

    Chaz

    Thursday, October 3, 2013 8:35 AM

Answers

  • 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 &...)

    https://goo.gl/IUQUN2 (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