Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2020, 02:19 AM
greatinfoteam greatinfoteam is offline INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Windows 8 INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Office 2016
Novice
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets
 
Join Date: Mar 2020
Posts: 3
greatinfoteam is on a distinguished road
Exclamation INDEX/MATCH that work on Master Sheet to collect data from 12 sheets


Hey all Excel experts
Someone told me to post my question as a New Thread so i am posting my problem here again with all details

I am working with 12 sheets and then have Master sheet. By defining these 12 sheets to a name range, I am able to do it with a formula that only look in 1st sheet and not working for the remaining sheets.
to understand my problem please see the attached file.
Attached Files
File Type: xlsx example.xlsx (295.6 KB, 3 views)
Reply With Quote
  #2  
Old Yesterday, 06:52 PM
xor xor is offline INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Windows 10 INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,036
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Credit goes to Jeff Lenning

Take a look at:
Attached Files
File Type: xlsx 3d_VLOOKUP.xlsx (327.3 KB, 3 views)
Reply With Quote
  #3  
Old Today, 08:00 AM
greatinfoteam greatinfoteam is offline INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Windows 8 INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Office 2016
Novice
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets
 
Join Date: Mar 2020
Posts: 3
greatinfoteam is on a distinguished road
Default

Thanks dear
but i dont want to use vlookup bcoz it cannot look to the right side of a column and the file is only as a reference and original files have many columns some are to left and some are to right of the base column. So need to use INDEX/MATCH

thanks
Reply With Quote
Reply

Tags
index, indirect, match

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets greatinfoteam Excel 1 03-26-2020 12:54 AM
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another robertjohn81 Excel 1 01-19-2017 11:20 AM
Complex calculation from multiple sheets to master sheet inreality01 Excel 49 01-06-2016 03:09 PM
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM


All times are GMT -7. The time now is 10:56 AM.


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