+ Reply to Thread
Results 1 to 3 of 3

database function and recovery

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    NY, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    database function and recovery

    Hello. I have a data base like this:

    Name Type City Date Sum

    1.
    2.
    3.

    The criteria field is like this:


    5 Name City
    6

    The names must be in a list. I have to show all names that are in the same city with the chosen one (from the list in the 6th row).
    In the results field I have to show only name, city,date and sum.

    How to do this?

    Thanks.
    Last edited by gangnam; 11-29-2012 at 10:24 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: database function and recovery

    Sounds like a homework assignment to me. Take a look in XL Help at the VLOOKUP function, and also INDEX/MATCH.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    11-29-2012
    Location
    NY, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: database function and recovery

    It is a simplified version of a task I have to prove to my brother. So, yes, it is like a homework, indeed.
    But, could you help me?
    Thanks!

+ 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