Get instant live Excel expert help with MATCH Functions

“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

I need to put a formula in cell G8 with the HLOOKUP formula with an exact match to return the last name of the operator assigned to the call.
Solved by S. F. in 15 mins
Hi there, I need to fill out the yellow section of the workbook. I need a formula which can drag the data from another work book onto this spreadsheet and one that I can just use for every week. Ideally I would want the formula to match the cell with the week number. I am needing it to find the week number and transfer the formula for a 1 week forcast in one cell, a 2 week forecast in another cell and finally a 3 week forecast in a third cell. Hope you can help. Thanks
Solved by T. J. in 20 mins
Use a VLOOKUP function to return the proper amount in C8, making sure to specify an "Exact" match in the function.
Solved by S. L. in 28 mins
In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00.
Solved by E. Y. in 27 mins
I am trying to match different rows together and receive a count of how many match the criteria with row I. Basically for row Y i want to count how many instances are both nfp for rows I and K. Another problem is how would I do it so it would give me a count for how many are nfp in row I and fp in row K. I am doing this multiple times for each value of c.
Solved by V. A. in 23 mins
need to find values in sheet1 for columns D, E F from sheet2. There are no unique values. Need to lookup using column B and column C from sheet1 and match with sheet2.
Solved by S. B. in 28 mins
need to tweak an index match formula to include a criteria
Solved by T. E. in 23 mins
I want the first 4 digits of column AC, AD and M to match. if not highlight all three cells in red if not matching. (note: first 4 digits only)
Solved by E. Q. in 12 mins
My excel file is returning #REF error after clicking a userform. This is because the userform query is not executing if index match query correctly. But I am unable figure out how to change it to do the index match formula correctly. It's a macro file.
Solved by B. B. in 17 mins
I am trying to understand how a a particular formula works VLOOKUP(list,N:O,2,FALSE)*IF(G19>0,G19,1) I just started a new job and I am trying to understand how the formula placed in front of me interpretes. =INDEX(LIST1,MATCH(0,COUNTIF($N$14:N18,LIST1),0))
Solved by I. Y. in 12 mins