Results 1 to 8 of 8

Help with Index/Match on two criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-21-2014
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    232

    Question Help with Index/Match on two criteria

    Hello folks,

    I have a field that I need to populate from a datasheet containing computer or phone tags.

    The formula I've tried to build looks up staff initials, then goes to find either if the device is phone or computer.

    I'm getting odd results and have tried a few things but no joy.

    Funny thing is one of the formulas works, the other not, yet only one parameter changes.

    Sheet attached - the data will always be text string in this instance.

    Any pointers are welcomed, thanks,

    Ian
    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 fails when the Match Criteria is determined by a formula result
    By JeffGrant in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2021, 12:39 AM
  2. VBA function to match multiple criteria faster than vlookup or index match
    By bkav1991 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2020, 09:14 AM
  3. Replies: 1
    Last Post: 03-01-2020, 10:36 PM
  4. [SOLVED] Combining INDEX/MATCH with several criteria and INDEX/SMALL
    By Dresas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-15-2018, 11:02 AM
  5. VBA Code for Index/Match/Match to input into excel based on 2 criteria inside form
    By Carl Fisher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2017, 12:11 PM
  6. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  7. Replies: 6
    Last Post: 04-30-2014, 02:42 AM

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