index/match/if/and

Hello, Excel wizards, I hope you are doing well. I am trying to use Index/Match To locate the Nth instance of specific text. The catch: Nth instance can change Both Criteria are in Col A What I want to locate: Service ID for IDS where the Access number is 111111111 (Purple cell, Col A...

SHEET 1 PATIENT NO. | SERVICE DATE | PATIENT STATUS 1 | 08/01/2015 | ? 2 | 09/25/2015 | ? 3 | 04/03/2016 | ? 1 | 05/15/2016 | ? 3 | 05/20/2016 | ? SHEET 2 PATIENT NO. | SERVICE BEGIN DATE | SERVICE END DATE | PATIENT STATUS 1 | 08/01/2015 | 08/30/2015 |...

Hi, Want to extract data from a table based on certain criteria to create data for a scatter gram chart Extracted data will be in two columns of data & multiple rows; not just a single cell. I am looking for a way to put extracted data into a range of cells not just a single cell. Goal...

Hello forum, I have a large amount of information that I am using index, match to lookup what I need to combine. In between these lookups, I have char(10) to make it easier to read and review. My problem comes when the lookups do not return anything the char(10) still apply which make the...

I apologize in advance if a similar problem is already posted. I’ve been reading through the forum for a couple days and haven’t been able to find a solution.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’m having trouble creating a formula that will...