Results 1 to 13 of 13

INDEX MATCH with multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    United States
    MS-Off Ver
    2019
    Posts
    77

    INDEX MATCH with multiple columns

    I have a spreadsheet that has a list of companies and various pieces of information about each company. I am trying to write a formula that when I type the company name in I1, employee population, headquarters, revenue and specialty populate. INDEX MATCH is great if the companies were in ONE column, but the company name could be in any of the first 4 columns, which is where I need help.

    If possible, I am trying to avoid formulas that use entire columns (ie E:E) and any 365 formulas.

    Attached is the workbook, but here is a photo as well:

    Untitled 2.png
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index/Match multiple criteria but searching for matches in multiple columns
    By stearno in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2020, 11:09 PM
  2. [SOLVED] Index match to sum multiple match columns
    By rosboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2018, 04:14 PM
  3. Match/Index Multiple Columns
    By fredlo2010 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-15-2018, 03:43 AM
  4. INDEX MATCH MATCH multiple columns with same heading
    By djm198 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2016, 02:34 PM
  5. [SOLVED] Index / Match across multiple columns
    By Chad B in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 11:52 AM
  6. Index Match multiple columns
    By bmhalula in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-11-2013, 01:06 AM
  7. [SOLVED] Index/Match across multiple columns
    By BB1972 in forum Excel General
    Replies: 2
    Last Post: 07-27-2012, 12:05 PM

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