index/match

Ciao All ~ Attempting to return the minimum value of a Range based on input from a Combo Box. Combo Box returns value in cell BM6 : 1,2,3,4 Set this table up to use Index/Match formula on : BR BS BT BU 1 S13:S49 W13:W49 AA13:AA49 2 T13:T49 X13:X49...

I have the following array formula: ={INDEX(r_base_liability,MATCH(1,("Liability"=r_peril_liability)*(i_score=r_score_liability)*(i_liabilit_bucket=r_terr_liability),0))} This performs a 3 way look up, and so far it is working fine. However, I want to loop through the parameters i_score, and...

Hello, I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having...

Hello everybody, I'm trying to put together an Index/Match formula. I have two tabs and both have a column with user id's. The second tab also has a ProposedStartDate column and DateClosed column. In the first tab I want a formula that will look up the user id and return 0 or 1 if that user has...

I have a INDEX/MATCH formula, whenever it encounters a duplicate, it is being ignored. Otherwise it works fine =IFERROR(IF(COUNTIF($J$3:J3,J3)=1,MATCH(J3,INDEX(Input_Events,,5),0),MATCH(J3,INDEX(INDIRECT(ADDRESS(ROW(Input_Events)+K2,6,1,1)):data!$J$102,,2),0)+K2),"") Thanks

hey guys, i have a VBA coding problem and i am not sure if i need to write in index/match formula into my vba or if theres a better way to build this. I have a list of numbers <tbody> <tbody> 1 test1 3 test2 5 test3 8 test4 11 test5 13 test6 15 test7 </tbody>...

How to I test the result from either VLOOKUP or INDEX/MATCH and then put it under the relevant column? I have entered 2 examples below of where I would like the values to show because they are within the value range for each ID I can't seem to add the greater than or less than elements to...

I have read here: https://professor-excel.com/performance-excel-study/ that INDEX/MATCH or VLOOKUPS can be up to 50% faster than SUMIFS but for some reason I am having a hard time replacing a SUMIF formula with either Index/Match or Vlookup. Has anyone done this in the past...

I have a vertical calendar I use to set up my yearly audits. I want to create a table with a function that will automatically return the start date and end date of each audit based on the first and last time the audit name appears (i.e., Test Wall). Is there an easy solution to creating this - I...

<tbody> A B C D 1 Lionel Messi Messi FC Barca No 10 2 3 4 </tbody> Hello Can someone help me please? Is it possible to use INDEX/MATCH so that (as in the table above) cell A1 displays 'Lionel Messi' if C1='Messi', OR D1='FC Barca No 10'. Thanks as ever.

Hi team, I was wondering if someone can help me with an interesting lookup issue I am having. I will receive a file that will be similar to Tab 2, out of which I need to build a view similar to Tab 1 below (I have manually filled in the numbers, to show what those cells should read). I tried...

Hi, I'm tryng to Index Match from a Dynamic Range of 6 pairs of columns, The column work as: Col A= Numbers, Col B=Values Col C= Numbers, Col D=Values Col E= Numbers, Col F=Values Col G= Numbers, Col H=Values Col I= Numbers, Col J=Values Col K= Numbers, Col L=Values Notes: -.Numbers on each...

Preface: MicrosoftProject is not an option, and I am trying to avoid having to manually changecolumn names in the data output file. Thecolumns are not always in the same position in the data dump. Vlookup and Offset using the task numberdoesn’t work because the total number of activities on...

I found some "cascading" combo boxes, but nothing that I could modify to meet my needs. Also there is lots of discussions on "INDEX/MATCH vs VLOOKUP". Its sounds like INDEX/MATCH is what I should be using. I have two worksheets (pretty simply stuff) worksheet1 is a "customers" list (cust...

Hi team, I was wondering if someone can help me with the following: I have the below report that I receive (thousands of rows). I want to pull out certain countries into another tab that are relevant to me. I wanted to use index/match to pull this information, however I am not sure how to do...

Hi all my first time here with a question I'm hoping you can help with. I'm using index/match to pull data from Tables ... I'm comfortable with index/match .. it's the naming of the tables that I'm struggling with, and utilising those in formulae (I'm new to Tables) This formula is working...

I have the following columnar data: Account Division Amount I would to convert this to the following format: Div Div Div Div Account Amount Amount Amount Amount Can I use the...

Scenario: I have a workbook with two sheets (calendar, Events). On the Events sheet I have 4 columns; Date(A), Time(B) , Description(C), and Location(D). Now on my Calendar page I want to display the Events that correspond to Today(). My Index/match finds and displays the first match, But How...

Hi, I am having difficulty in hiding a "0" if nothing is found using the following formula =IFERROR(LOOKUP(2,1/($AZ$13:$AZ$5000=D12)/($AS$13:$AS$5000=F12),($AX$13:$AX$5000)),"") is there a way for the formula to return "" instead of "0" Many thanks

Hello! I have this function: =SUM(INDEX($C$212:$AM$212,1,MATCH(TRUE,$B$263<C3:AM3,0)):$AM$212) It should calculate the sum of a range of cells. That range is defined by the INDEX/MATCH function. The end of the range is easy, I want it to be $AM$212. The start of the range is tricky. I want...