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'm stuck. I need a formula that will find the contents of cell A! in sheet1 in column C of sheet 2. If there's match then put in the contents of column A of the same row, into A3 on sheet1. Then to do the same for column B on sheet 1. Etc.
Solved by C. U. in 14 mins
VLookup reporting n/a when trying to match a date/time in an array. It works some times and not others. Relevant cells are i1063:l1067. AI1063:AI1067 confirm that the value of the lookup value is the same as the value in the array but still get random n/a's. There is no pasted data in the sheet and I have tested the most common n/a errors. Index/Match displays same problem.
Solved by K. S. in 22 mins
I am trying to use the vlookup and or match /index formula on sheet two to get the code column filled out using the company name and city as a criteria and keep getting an error. Can you please help
Solved by T. Q. in 20 mins
using vlookup, look at the values in column C and Column K and if a match is found, pull match adjacent info from Column J and place the value in column D
Solved by E. E. in 19 mins
I need to find which 1-3 entries from the DR column added together subtracting the sum of 1-3 CR columns added together will match $0.85.
Solved by A. J. in 28 mins
Hi. This is quite hard to explain but hopefully the document will help! I have a s/sheet looking at a five year replacement plan for their PCs. I have a list of Locations (Labs) in a uni that contains the number of machines, how much it will cost to replace and a year that (1-5). At the moment they were populated manually. But if they decide they want to change, for example Lab B from the first year to the 3rd, it then needs to be done manually. What I'd like to be able to do, is, if the year is changed in column E, then the boxes / fields to the right get updated. I know I can do this with multiple pivot tables, but know that it could also be done with formulas. In G5 for Year 1, I have used the Index and Match functions to return Lab B. I'm guessing I might need OFFSET, (which I don't know much about as yet) but before I went ahead and researched it all, thought I would ask. Current formula (in G5) here is: =INDEX($B:$B,MATCH(1,$E:$E,0)) Thank you.
Solved by I. U. in 23 mins
Good day. I am looking for a formula. On excel I have to match number 1 2 or 3 with 13 numbers with commas in 500 rows. Sample is the right line 1,3,1,2,2,3,1,2,3,1,1,2,1 What is the possibility to match it according to the row Ex 1,3,1,2,2,3,1,2,3,1,1,2,1 To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1 The 2,2 is wrong or Ex 1,3,1,2,2,3,1,2,3,1,1,2,1 To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1 is right Please help me
Solved by I. Y. in 21 mins
I have 2 tables 1) where one is having name of the student with registration no. (Registration) 2) Other table has attendance with only registration no (Attendance table) I tried to match 2 tables with registration no, however first table have name with registration no therefore it will not show as match. How I can match the 2 tables???
Solved by X. W. in 19 mins
In the loading sheet, The calendar sheet is used as a reference to start the calculations in the "count down" sheet My formula lookup up a reference values and then adds the corresponding "countdown sheet" values. Row 3 works perfect because it in in the match is found in the first column, column. Row 4 finds its match in the second column, because of indexing I loose I set of data, the total row values should add up the values in column "B" Rows 4,5,6 etc each loose an additional column can u please help
Solved by K. S. in 24 mins
In the Shop loading sheet, I lookup the calendar sheet and where it finds a match ( Q???? numbers) , I want the formals to lookup the count down sheet and match the respective hours, but I only want the. when the formula finds a match. When it finds a match I want it to always start in the first match column and thereafter index.
Solved by Z. F. in 12 mins