Thread: [Solved] update master list automatically from other worksheet
View Single Post
 
Old 08-21-2017, 01:09 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 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