Excel Match return different row number

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Match return different row number

FAQ

Thread Tools

Display Modes

03-01-2017, 07:52 AM

kimak

Windows 10 Excel Match return different row number

Office 2016

Novice

Join Date: Feb 2017

Posts: 8

Excel Match return different row number

Hi there, i have this problem when using the match function. I got two different workbooks, A and B. The former has fewer row of data than the later. So I used match function on A in order to find matching row number. Each row in A matched with B until at the 1033th position, the row number returned was supposed to be the same which is 1033 but I got 1034 instead. Sorry for my English, hope you guys understand. Thx.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match	krispykreme	Excel Programming	1	09-09-2016 11:25 AM
How to make MATCH/INDEX formula return multiple successive responses.	danigirl121	Excel	7	06-08-2016 01:57 PM
Not Exact Match to Return a Value	Alaska1	Excel	0	02-19-2015 06:58 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:01 PM.