Get instant live expert help with INDEX Function in Excel

I have a value in B2. I want it to find the value in the first column of a named range and return all the data from the same row of columns 2,3,4,5 and 6 of the same named range for as many rows the match value is found. I am currently using:- =IF(ISERROR(INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2)),"",INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2)) But I am returning duplicate records for some reason

Looking for formula modernization/effiency. Potent IF=Statement to INDEX upgrade if possible,

Please could you help me translate this formula to use INDEX and MATCH instead of VLOOKUP: =iferror(vlookup(A10,'Funds Included in Starting Balance'!$A$2:$C$9,3,false),0)

how can I replace a sumproduct formula to an index match formula

how can I change the sumproduct formula to an index match

Hi I need a suitable formula index match or sumproduct to calculate Material price saving

Using appropriate Lookup, match and/or Index functions in Excel (without using VBA) create a worksheet that identifies: a) Which students in the English class are NOT studying science b) Which students in the science class are NOT studying English the formula i used was: =IF(ROWS(D$8:D19)<=SUMPRODUCT((--ISNA(MATCH($A$8:$A$307&$B$8:$B$307,$H$8:$H$307&$I$8:$I$307,0)))),INDEX($A$8:$A$307&" "&$B$8:$B$307,SMALL(IF(ISNA(MATCH($A$8:$A$307&$B$8:$B$307,$H$8:$H$307&$I$8:$I$307,0)),ROW($B$8:$B$307)-ROW($B$8)+1),ROWS($D$8:D19))),"")

I need help with index match formula - when I drag down shows N/A

Hi Experts, I have an Task im stuck with my knowledge. I would need to fill Column R with correct Names. This depends on the Pilotmatrix Sheet as some pilots are not available on some times/trips. My solution does not work as it only works with ongoing flow. I would have an idea with INDEX and ONGOING formula, but i did not find a way so far. Can anyone help me with this?

How can I built calculate number of days in with index match