Results 1 to 4 of 4

Use a VLookup to return multiple values

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2006
    Location
    Whitstable, Kent, UK
    MS-Off Ver
    MS 365
    Posts
    26

    Use a VLookup to return multiple values

    Hi.
    I'm seeking some assistance. I have a workbook with 2 sheets.
    The sheet called 'data' contains all purchasers names (which do get repeated), the item they bought and 3 item costs, all in range A1:E15.
    The 'lookup' sheet allows the user to enter a purchasers name in cell B1, then I want all the items that purchaser bought listed with the corresponding item costs.
    I've attached a sample spreadsheet.
    Thanks in advance for any assistance.
    Kenneth.
    Attached Files Attached Files
    Last edited by Kennethc; 04-08-2009 at 08:28 AM.

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