Here are some problems that our users have asked and received explanations on
This formula from MS excel is giving an error in Google sheets
=DATE(AB3,INDEX({1,2,3,4,5,6,7,8,9,10,11,12},MATCH(AB2,monthNames,0)),1)
=IF(C7="","",INDEX({"Su";"M";"Tu";"W";"Th";"F";"Sa"},WEEKDAY(C7,1)))
Solved by B. L. in 17 mins
Formula to match, index info is not working on google sheet.
Solved by T. D. in 29 mins
can you help with google spreadsheets index and match equation
Solved by X. H. in 29 mins
index,indirect,match,hlookup,different sheets,drop down lists,different tables sizes,buttons
Solved by G. H. in 15 mins
I need to match the first name and last name fields, and index match on the ID field. There are 2 seperate sheets here.