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 manage a few accounts in adwords. I am trying to create a visual budget tracker that shows for different accounts the spent up to now from the beginning of month, and the spend today and yesterday. The idea is to drop the raw data and automate its tracking, I managed to do it for totals, but not for spent yesterday or today. Tried with vlookup and match but maybe I am doing it wrong
Solved by E. H. in 21 mins
Hi, I am having trouble with index and match. i have one colume for index B but need to match over a number of different colums J to U. i have goten this far and i tryed many different variations currently =INDEX(B2:B40,(MATCH(E1,J2:J46,(MATCH(E1,K2:K46,0))))) this retuns the correct index but seem to jump over J =INDEX(B2:B40,(MATCH(E1,J2:J46,0))) works but i need to sherch over colunms J to U please help
Solved by K. Y. in 22 mins
What I’m trying to accomplish is the following: I will be populating the weekly data for each week and location id (TOP PART OF THE SHEET). I would like to create a formula that adds each week on to its respective month and then add the Year to Date Column (BOTTOM PART). I have tried sumifs, sumproduct, index and match in excel; but have not been able to accomplish that.
Solved by B. C. in 21 mins
I'm trying to search column F. The column has (two or more) 4-character SIC codes in it. I'm trying to filter out all rows that have at least one SIC code that starts with "80" in that specific column, and then delete the rows which don't match my search. It's a document that shows mergers and acquisitions between pharmaceutical companies and healthcare providers
Solved by V. S. in 11 mins
I run two reports each day and need a match formula that I can just copy and paste each day to match the numbers in A column on uploads tab to A column on FollowUps to see if the ppl on list on sheet 1 are on sheet 2. Then I need the formula that I can copy and paste if I do not rename the tabs and just leave as sheet 1 & 2
Solved by T. S. in 26 mins
My cell has call outcomes within it. The cell includes CALL OUTCOME, EMPLOYEE NAME, BRANCH, MANAGER, LEAD I am trying to use a COUNTIF formula to count how many surveys were booked per lead. Here is what I am using =countifs('WPC Emails'!$A:$A,$C$1,'WPC Emails'!$G:$G,"*.O: Survey Booked.*,*Lead: Commercial.*") However, this formula is only returning results that match the order in which the formula has been typed - ('Survey booked' then Commercial') I have 7 cells that contain both these trigger words but 'Commercial' is first then 'Survey Booked'. How do I work the forumla so that it doestn matter which trigger word comes before the other? I just want the formula to tell me how many cells contain 2 specific phrases. thanks
Solved by F. J. in 25 mins
I have a Userform that is supposed to take the input from a barcode scanner and then search through the previous logged items to find the cell that matches the number that the barcode scanner output. Right now I am having issues getting the userform number to match the list that is present in the whole sheet, I think it has to do with defining the userform value as a string or number, but I cannot figure out how to adjust that. I would also at some point like to make the Userform input automatic, so that as soon as you scan the barcode with the scanner, it will search and log the required information.
Solved by X. H. in 21 mins
Need a copy and paste formula that I can use daily to match staff codes between two tabs. Need to see which codes on tab 2 appear on tab 1.
Solved by X. J. in 20 mins
I am trying to do two drop down boxes with one dependent on the first. I am using =Index(Options, Match(C5, Drugs, 0)). I am using this in Libre and it works fine but in Excel it gives me a #REF error every time.
Solved by V. E. in 30 mins
I have three different sheets within one Google Sheet. One of those sheets contains a column of dates. I want to use countifs excel. The date must be greater than or equal to a cell on another sheet, and a cell next to them must match text from another sheet. I am attempting to use a countifs formula, however, I am not having any luck.
Solved by K. L. in 12 mins