+ Reply to Thread
Results 1 to 7 of 7

vlookups wont work as multiple instances, what will?

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    vlookups wont work as multiple instances, what will?

    Hi all,

    I am looking for a formula that searches the whole page and if it matches a name in my table will then retrieve the informatiom from cell a1, the problem i am getting is that there can be multiple instances of this name which will have different info in cell a1, vlookup wont work, i can get if and match to do it so am thinking of another way bit dont know where to.start.

    What sort of formula would search the whole of book 1 and when it matches a name of TABLE1 it returns the value in cell 1, but then when it finds the next name that matches a name in TABLE1 (could be the same as the first) it enters that rows relevent information from cell 1, in the end i want a list of all the names that match a name in TABLE1 and next to those names i want the relevent information in cell 1 of that names corresponding row.

    For instance. In TABLE1 i have 3 names John,Jeff and Ted. There is a spreadsheet that logs what dates people worked on but i only want the dates John,Jeff and Ted worked listed, what would that equation be?

    hooefully i have explained well and appologise.if.not.

  2. #2
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: vlookups wont work as multiple instances, what will?

    Could you please upload your spreadsheet with any sensitive information removed.
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

  3. #3
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    Re: vlookups wont work as multiple instances, what will?

    Quote Originally Posted by Craig K. View Post
    Could you please upload your spreadsheet with any sensitive information removed.
    How do i do this, i have read the rules but cant see how too.

    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: vlookups wont work as multiple instances, what will?

    Click go advanced
    under additional options select Manage Attachments

  5. #5
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    Re: vlookups wont work as multiple instances, what will?

    Quote Originally Posted by Craig K. View Post
    Click go advanced
    under additional options select Manage Attachments
    Brilliat thanks.

    What i am looking for is an equation that with find all the instanses of FULL in column D and paste the name, shop and date from columns C, B and A, i am looking at this information being pasted into book 2

    many thanks for all your help.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: vlookups wont work as multiple instances, what will?

    For what you want, you need to use a pivot table. See attached.

    oneblondebrow solution.xls

  7. #7
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    Re: vlookups wont work as multiple instances, what will?

    Thanks for all the reply's but a pivot table is not really what i am looking for, I have attached a new spreadsheet that has been revised with more of what i am looking for, It is in order to pay my part time agents for the customers they deal with, i have to create a report which is on page 2 that only needs to find all the names in the part time box on page 1 and then when it finds the name it needs to fill in all the columns on page 2, Is there a formula i can put into each cell that would be able to do this? maybe a Index/Match or as there are multiple instances of the same name on a daily basis would i need to use OFFSET? its in Excel 2003 by the way.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1