Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2017, 07:52 AM
kimak kimak is offline Excel Match return different row number Windows 10 Excel Match return different row number Office 2016
Novice
Excel Match return different row number
 
Join Date: Feb 2017
Posts: 8
kimak is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-01-2017, 09:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel Match return different row number Windows 7 64bit Excel Match return different row number Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post your sheet ( click Go advanced - manage attachments). Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel Match return different row number 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
Excel Match return different row number 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 Match return different row number 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 05:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft