Get instant live expert help with INDEX Function in Excel

trying to index match first and last names to cell phone numbers to flatten out this excel file. sheet 2 and cell phone sheet

Index match using dropdown menu. I'll let you know what tab to use.

Im using index match to find names of the lowest 5 players in a leaderboard. However the issues arises when players have a score of 0 as it displays the same name for all 0 values. See picture

11. In cell I6, create a formula using the VLOOKUP function to display the number of calories in the selected boxed set. Use the boxed set listed in cell I5 as the lookup value, the range A14:D17 as the table array, column number 2 as the column index number, and FALSE as the range lookup value. Use absolute references for cell I5 and the range A14:D17

hiii.. i need you to extract data depending on date and return value... of B column using match function exceln thanks

iii,, i need you to extract data depending on date... just fill column b using index and match thanks

I'm trying to get a similar function to work on my excel. =ARRAY_CONSTRAIN(ARRAYFORMULA(index('Contract Month Detail'!$E:$E,match(C6,'Contract Month Detail'!$N:$N,0))), 1, 1)

I am having an issue with hlookup - need to return multiple values but can only get the first value extracted - possibly use of index would work , but cannot figure it out.

I need help with an Index Match function excel. I'm trying to pull the values from the Amount column (BK) in the Deals - All deals tab into the HubSpot Amount column, column AR, in the Data tab. However, I need the values in the Month (Column B of the Data sheet) column to match with the values in the Close Date Converted (column U of the Deals - All deals tab) column. Additionally, the Primary Account Number (column E of the Data tab) need to match the Mailgun Account ID (column L of the Deals - All deals) as well.

My Index function won't resolve in Excel 365. I want the function to return the value at an interesecton of a row or column of a pre-defined array which I have also setup as a named Range. The syntax I am typing is: =INDEX(Db1_Pageviews|$C$7|C$8). here, C7 gives the row number and C8 the column number. Why is Excel not resolving this?