+ Reply to Thread
Results 1 to 2 of 2

Excel database lookup and list

Hybrid View

  1. #1
    Registered User
    Join Date
    09-24-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    Excel database lookup and list

    Hi,

    I am struggling to get my head around this.

    I am trying to make an search function in an excel spreadsheet.

    I want a user to input a skill category and a level of experience into two separate cells. I want the output to be the total number of people who have experience at that level for that skill category.

    A bonus would then be to list the names of those people afterwards.

    The search boxes are to look like this:
    Untitled2.jpg
    And the database to look like this:
    Untitled 1.jpg

    Any help would be appreciated.

    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Excel database lookup and list

    Hello
    Take a look at the attached file. It might give you an idea has to how to proceed using formulas. The two green columns have the formulas with the names column being array formulas entered with Ctrl + Shift + Enter.

    Hope this helps.
    DBY
    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)

Similar Threads

  1. [SOLVED] lookup data in the database of Excel Tables WITHOUT AN ARRAY FORMULA
    By carsto in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-20-2015, 06:42 PM
  2. Need to create list from Excel database all within the same Workbook
    By Backpack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2015, 04:07 PM
  3. Excel lookup from Access Database
    By jjburt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2012, 02:37 AM
  4. Excel 2007 : Excel database lookup problems
    By Jnstone in forum Excel General
    Replies: 3
    Last Post: 01-18-2011, 12:10 PM
  5. Replies: 6
    Last Post: 11-21-2006, 07:35 AM
  6. [SOLVED] Lookup In Excel from Access Database
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2006, 12:10 PM
  7. how do i list an access database list in excel
    By Markp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 04:01 AM

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