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 am wanting to bring & match information over from 1 excel spreadsheet onto another. I have client names on the first spreadsheet & client names & client account numbers on the 2nd spreadsheet. I require the client account numbers to be matched to the corresponding client name on the first spreadsheet
Solved by B. H. in 15 mins
i am using a formula on excel that when a month is put into cell C3 it populates data from a different tab into a field. the formula i am using is =INDEX('ALERT REGISTER'!B:B,MATCH(C3,'ALERT REGISTER'!A:A,0)+1) so i add the +1 at the end so that it doesnt generate the same data each time but the one below, so the next formula will have a +2 on the end to generate the next set of data after that and so on... the problem i am having is when i enter the Date into C3 for example April-17, it will populate all of Aprils information but because i have +1, +2, +3 etc it will also carry on and bring up Mays information when really i want it to stop at April. can you help with this?
Solved by T. S. in 28 mins
I have a pivot table with the names of all of my vendors and the YTD sum of checks paid out. In a second spreadsheet, I have a list of vendors with their addresses. I need to be able to match the Vendor names to their addresses without having to do it manually, one by one.
Solved by K. J. in 15 mins
need help with excel match index function to up date information as I add more data weekly not having to adjust every single formula.
Solved by X. Q. in 11 mins
Trying to match data on 2 different tabs and im using addresses as a reference. I would like to get some help on this
Solved by G. E. in 20 mins
I have numbered by list of inquiries as E00001, E00002, E00003 and so on.. (row wise) However, each inquiry may have more items and hence i number them as E00002a, E00002b and so on. (consecutive rows) I my next sheet i would like to link the inquiry nos. (i.e if i enter E00002 all the rows which have E00002 including E00002a, E00002b should be listed consecutively as in the inquiry sheet. I tried with =INDEX(Marketing!$A$6:$A$22,MATCH('Mktg-Comm'!A19,Marketing!$A$6:$A$22,0)+1) In the above formula all the Enquiry nos. next to E00002 is being listed. Need a formula to break the loop once E00002 and the consecutive items pertaining to E00002 is over.
Solved by V. Y. in 23 mins
There are over 50 locations that the individuals can be at. Looking at where they have been, each location has a code (A, B, or C) . The locations and codes are on sheet "ABCCodeListing." I need the cell for "A" in worksheet 1, to state "A" if the individual has been at any location that denotes "A" within worksheet 2. I thought I had this figured out, but I don't. Some individuals go from a location, to another, and back to the same location. My current formula causes them to cancel each other out when this happens. Formula: =IFERROR(IF(MATCH(1,("A"=CodeList[A])*(($CZ3=CodeList[Org No])+($DA3=CodeList[Org No])+($DB3=CodeList[Org No])+($DC3=CodeList[Org No])+($DD3=CodeList[Org No])+($DE3=CodeList[Org No])+($DF3=CodeList[Org No])+($DG3=CodeList[Org No])+($DH3=CodeList[Org No])+($DI3=CodeList[Org No])),0)>0,"A",""),"") I use CONTROL-SHIFT-ENTER at the end. It works... except for the repeats. Any ideas?
Solved by V. D. in 16 mins
The quantity from the availabletosell spreadsheet should be upadated to the Nuorder spreadsheet. Sku is slightly different - for the available sell spreadsheet sku to match the second spreadsheed need to remove the first digit from the sku and separate the digits after the last "-"
Solved by A. U. in 12 mins
Hi, I am trying to find common numbers for called/received phone numbers between different people in phone call data. I also trying to find a way to combine the total count of calling and receiving number between parties in pivot. At the moment it is separate and need to look at the numbers to match up. I can find the common numbers in a pivot, but real phone data has hundred of entries, the columns in pivot for receiving number cannot take so many entries. Need a simpler way to analyse the data.
Solved by Z. Q. in 17 mins
Hello I want a formula that will recognise a date in a cell to match to a range and then count products sold
Solved by B. B. in 18 mins