+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP or something with multiple unique return values in a list?

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    Cincinnati
    MS-Off Ver
    Excel 2003
    Posts
    5

    VLOOKUP or something with multiple unique return values in a list?

    I am trying to help my mother create a document to capture all of her supporters contact information on one sheet, their contribution via check information on another sheet, and be able to have a report showing each check received on another as a receipt at the end of the year.

    Sheet 1 capture all of her supporters contact information

    Sheet 2 Use a Data Validation(to minimize human typing errors) on sheet two to name the entry of the checks as well as the amount, check number, and any notes on the check.

    Sheet 3 will pull information from sheet 1 and 2 to create a yearly receipt (here is the catch) listing each check and its details separately... There could be one check there could be 15...

    I had it working fine until I realized using VLOOKUP would only return the first entry found... I don't know if there is an IF previous row = ? then return next entry. Or if there is a index/match/something function that would work... I will attach my current workbook to give you a better idea of what I am doing.

    Any information would be most helpful. Thanks you!

    Test Account and reports.xls

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: VLOOKUP or something with multiple unique return values in a list?

    Hi

    Edit the formula in Report!B15, remove the {}, then hold down the shift and ctrl keys, then press enter. This will array enter the formula and will automatically enclose it with {}.

    Edit the formula in C15 to change the column(b1) to column(C1). Then array enter the formula. Copy down.

    I can't process the other items as the named ranges aren't complete in the example workbook.

    HTH

    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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