Results 1 to 3 of 3

macro for index and match multiple columns in a single formula

Threaded View

  1. 02-13-2016, 02:47 PM #1
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,142

    Question macro for index and match multiple columns in a single formula

    hi I am trying to match a sequence no from report sheet to a data entry sheet using index and match in a single formula but there are three criteria columns

    Tariif ,Description and origin as criteria

    Can anyone help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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 values in single row, return header value(s)
    By grrliz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2014, 07:21 PM
  2. index match minimum 2 matches or more with a single formula , maybe using indexed value as
    By polease in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 11:00 PM
  3. [SOLVED] Formula to Index & Match for Max Value across multiple separated columns
    By Bravmik in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-30-2013, 05:38 PM
  4. [SOLVED] index match multiple columns
    By mma3824 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 04:02 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 Across Multiple Columns
    By FFastZB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2013, 04:58 PM
  7. [SOLVED] Index/Match against multiple columns
    By paradox34690 in forum Excel General
    Replies: 8
    Last Post: 04-28-2012, 12:43 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1