Results 1 to 4 of 4

INDEX SMALL Formula

Threaded View

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

    INDEX SMALL Formula

    I have a range within a spreadsheet that shows the date of births for employees and any dependents, whether they are a spouse or child, within a column labeled Relationship. The possible relationship values can be Spouse, Ex-Spouse or Domestic Partner and the challenge with the INDEX SMALL formula I created is it only looks for "Spouse", but I am looking for a way to replace this part of the formula to have it search the list and if true, provide that value.

    IFERROR(INDEX($D$1:$D$11,SMALL(IF(($A$1:$A$11=H2)*($C$1:$C$11="Spouse"),ROW($B$1:$B$11)),1*1)),"")
    This formula works great if there is a "Spouse", but for any other variation (Ex-spouse, Domestic Partner) it will provide a blank, which makes sense.

    The question is how do I update this part of the formula to look at the list in F2:F4 and if there is a match for that employee, then provide that word match meaning if there is an Ex-spouse, then the formula would give Ex-Spouse as the answer?

    ($C$1:$C$11="Spouse")
    Workbook is attached - thank you for your help!!
    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] Need help with Index Small formula
    By fatkinglet in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 06-17-2023, 11:14 AM
  2. Index SMALL formula help
    By MammuB in forum Excel General
    Replies: 5
    Last Post: 06-12-2023, 03:46 AM
  3. [SOLVED] Index Small Formula?
    By lalahaedong_excel in forum Excel General
    Replies: 3
    Last Post: 10-24-2017, 11:14 AM
  4. [SOLVED] ask formula index+small + if
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2015, 04:29 AM
  5. Index Small Row Formula
    By davidcharis16 in forum Excel General
    Replies: 3
    Last Post: 04-16-2015, 04:40 AM
  6. Problem with INDEX/SMALL in formula
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2015, 01:52 PM
  7. INDEX SMALL ROW Formula #REF! error.
    By elcasey125 in forum Excel General
    Replies: 3
    Last Post: 12-10-2008, 12:41 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