Here are some problems that our users have asked and received explanations on
INDEX MATCH INDEXMATCH GOOGLE SHEET ARRAY CONSTRAIN
Solved by Z. U. in 23 mins
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
I used Index/match and vlookup but i'm not getting the right match between data in two sheets