Get instant live Excel expert help with INDEX MATCH Function

Im thinking I need to use an excel index match multiple results but I want it to search through multiple columns and return values that aren't 0

Without using an index match formula could you please extract all the sodium results for each patient and make a table of them

trying to use index match formula to pull information but i have repeated items I am trying to match

Hello, I have a complicated multiple if statement that requires the use of an index match excel function to find the the closest value.

need help understanding index match and what this formula is about

Can you explain the use of INDEX MATCH. Thanks

I need to do a "fuzzy" index match or vlookup, but I am having trouble getting the wildcards to work. And I want to be able to do this without the fuzzy lookup add in, because I want to write a macro for this.

Trying to index match data but the outcome is incorrect

Col 1, Col 2, Col3, Col4, Col 5 etc Row 1 = Name, Date 1, Date 2, Date 3, Date 4 etc Row 2 = Name1, 82, number, number, number etc Row 3 = Name2, number, 82, number, number etc I am wanting a summary Cell based on todays date that can be used to select the name of a person with a certain number. So the formula uses the same row references but the column reference will change relative to Today(). So, when Today is Date 1, Name 1 would display as it has 82 in one of the cells. If today was Date 2 then Name 2 would display as it has 82. I'm looking at Index Match but i don't know how to make the range dynamic in this way

Using Index match formula to populate a list. While it works fine for most of the names, it is repeating the names due the same shift times being the same. IS there anyway for excel to list the next name down?