index match returns 0 for blank cell, want it to be "-" Asked 8 years, 8 months ago Modified 2 years, 8 months ago Viewed 146k times

Nov 9, 2017 · OFFSET is probably the function you want. =OFFSET(A1:A4,1,,2) But to answer your question, INDEX can indeed be used to return an array. Or rather, two INDEX functions …

Jul 10, 2021 · I am trying to set up and index/match but want the MATCH to match on 2 items but 1 of the items can exist in one of 2 columns, so I am trying to basically create an index match …

Aug 15, 2019 · Create a new column in sheet1 with the formula Cell M1 =MATCH ("*",G2:L2,0)&A2, then in sheet2 use the formula below, so what it does u make each row …

Sep 26, 2024 · Index trimmed input Use FREQUENCY to select unique values Alphabetize the trimmed, unique input using COUNTIF Remove blanks Removing blanks as second steps …

Nov 15, 2024 · I'm aware this could be solved by writing the Index-Match formula into the cells manually and dragging down, but I am trying to make it simple for the people who perform this …

Sep 30, 2016 · N 16 17 18 I now want to search for a specific Name and then for a specific letter within that names table, I then want to match this row number with a specific column. I tried a …

Mar 22, 2013 · I need to find a partial text in a specific range and get a value which is X rows under cell index of found text. I have tried with INDEX and MATCH functions but without …

May 25, 2024 · I tried using the INDEX and MATCH functions to get the column header name, but I can't figure out why the formula spills the value found into A8. For this, I don't need the value …

Jun 6, 2017 · using index match with sum if Asked 8 years, 6 months ago Modified 4 years, 11 months ago Viewed 21k times