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

Trying to match a value from one spreadsheet to a value in a range of another and return corresponding value
Solved by D. L. in 22 mins
I need to write a nested if statement. I have to identify those with a value greater than 0 in column A but have a zero value in columns C & D to return a value of "Lost" if the criteria matches and Active for those that dont match.
Solved by M. D. in 22 mins
use of solver To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by S. C. in 27 mins
i need to be able to type in the period number e.g. P1 into E3 on Sheet1 and bring up the figures from budget vs actuals FY18. Ive tried V and H lookups and an index match but cannot get it to work!
Solved by K. J. in 15 mins
Need VLOOKUP HELP. Trying to match the values in column A to a table range (AB:AD) . when the account number is found in the range, I want it to return the value in AD.
Solved by M. C. in 13 mins
1 tab houses job titles and status; create a separate tab that based on drop list (by department) the following statuses would populate/change when selecting different departments - # open, # cleared to start, # in progress -- by department. Have tried INDEX, MATCH and COUNTIF but does not work.
Solved by S. H. in 11 mins
I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.
Solved by M. A. in 29 mins
I'm trying to figure out how to construct a nested Match function within an index function.
Solved by A. L. in 25 mins
I tried to do an array formula but it won't take data from another worksheet in the workbook. Current formula is =index('Daily Report Log'!A9:A23, Match("*CFT*",'Daily Report Log'!M9:M23,0)) which I get the 1st date reference BUT not any other dates after. I'm currently using INDEX MATCH - which simply returns the first match ONLY. But there are multiple matches, that need to be listed. I need to see multiple matches listed. The data is coming from another worksheet within the workbook. Not on the same page.
Solved by F. H. in 24 mins
My sheet has donors details in and up to 30000 lines of data. I want to count the donations made for each individual person. Some make a few donations of a few pounds some make many donations of a few pounds, some make lots of donations of more money - so there is no set quantity. I have sorted by postcode - I thought if i could search down the post code, whilst ever a match - add the amount donated to a cell - when the field changes - total the cell. Next Would that work? Hope you can help us.
Solved by O. S. in 19 mins