Here are some problems that our users have asked and received explanations on
What I’m trying to accomplish is the following: I will be populating the weekly data for each week and location id (TOP PART OF THE SHEET). I would like to create a formula that adds each week on to its respective month and then add the Year to Date Column (BOTTOM PART). I have tried sumifs, sumproduct, index and match in excel; but have not been able to accomplish that.
Solved by B. C. in 21 mins
I am having trouble putting together text strings with an index match excel
Solved by C. J. in 13 mins
I keep getting #N/A when i do an index match, even though there is a proper match with the same formatting
Solved by E. S. in 20 mins
TEXT(INDEX(CalendarItemTimes,N20),"General") - can General formatting also include wrap text?
Solved by M. L. in 15 mins
I am trying to use a filter function (possibly in conjunction with vlookup or index) in order to match a name submitted via a google form to a roster on a separate sheet. It also needs to be able to pull in select cells from the form response sheet to the roster on the secondary sheet based on the name submitted.
Solved by G. F. in 20 mins
There are formula on sheet KPISCORES7_DM column "c", i want to understand why { used before = for index). Can you please explain.
Solved by G. Q. in 27 mins
just need to make it easier to match data across columns... index? match, if ands?
Solved by C. A. in 17 mins
I am trying to clean up a spreadsheet to return only the data I need. However, the data is formatted very strange and in some rows I need only information let contains certain letters. I think the most helpful is an Index match but I am not sure how to do this correctly.
Solved by Z. H. in 23 mins
hii im stuck with index and match formula,,,,,,,need some help
Solved by D. C. in 22 mins
I am trying to edit the formula in on the "Clean" tab "Move In" column to enter a value of "N/A" when the relevant cell found in the excel match and index which is a blank cell