Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2017, 01:09 PM
NBVC's Avatar
NBVC NBVC is offline update master list automatically from other worksheet Windows 10 update master list automatically from other worksheet Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

I apologize for the late response...been very busy at work....



Try:

Code:
=IF($A5="","",IFERROR(IF(COUNTIF(CV!$F:$F,$A5&"_"&0),INDEX(CV!C:C,MATCH($A5&"_"&0,CV!$F:$F,0)),IF(COUNTIF('CV-SKT'!$F:$F,$A5&"_"&0),INDEX('CV-SKT'!C:C,MATCH($A5&"_"&0,'CV-SKT'!$F:$F,0)),IF(COUNTIF(AR!$F:$F,$A5&"_"&0),INDEX(AR!C:C,MATCH($A5&"_"&0,AR!$F:$F,0)),IF(COUNTIF(LS!$F:$F,$A5&"_"&0),INDEX(LS!C:C,MATCH($A5&"_"&0,LS!$F:$F,0)),IF(COUNTIF(EL!$F:$F,$A5&"_"&0),INDEX(EL!C:C,MATCH($A5&"_"&0,EL!$F:$F,0)),IF(COUNTIF(ME!$F:$F,$A5&"_"&0),INDEX(ME!C:C,MATCH($A5&"_"&0,ME!$F:$F,0)),INDEX(GE!C:C,MATCH($A5&"_"&0,GE!$F:$F,0)))))))),""))
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2013 question - master list current list markecb Word 6 02-28-2016 01:51 AM
update master list automatically from other worksheet want to put ID no from worksheet ID no master..... mahfuz19 Excel 3 03-13-2014 10:37 AM
update master list automatically from other worksheet How do you update your source docs from a master document? Joyce Word 3 07-12-2013 08:54 AM
Excel 2010 slow update of worksheet bosve73 Excel 2 03-28-2012 05:14 AM
PowerPoint Master - 50 LINKED slides - SLOW Update salfonsi PowerPoint 0 09-27-2008 02:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 AM.


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