Microsoft Office Forums Excel Match return different row number

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,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post your sheet ( click Go advanced - manage attachments). Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
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


All times are GMT -7. The time now is 06:42 PM.


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