Get instant live expert help on index number formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Can index + match be used where the "match" is based off of a formula result instead of a number that is inputted?
Solved by O. H. in 28 mins
Hello how does vlookup work. I see on the formula that there is a value, table, index-number, [app_match]. Especially on calculations
Solved by V. J. in 14 mins
How can I built calculate number of days in with index match
Solved by C. H. in 19 mins
I have a formula that I was trying to use to get the newest date, but it only gives me the first date for the closest to zero client number that it has. I'm looking for the newest date for any client number on the named range of JUDI9 =IFERROR(LOOKUP(9.99999999999999E+307,MATCH(INDEX(Table_Query_from_GJ,0,1),JUDI9&"",0),INDEX(Table_Query_from_GJ,0,3)),N682)
Solved by A. D. in 28 mins
replace #NA to 0 in index match formula if I don't have the data in my index
Solved by I. Y. in 27 mins