![]() |
|
#1
|
||||
|
||||
![]()
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)))))))),"")) |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2013 question - master list current list | markecb | Word | 6 | 02-28-2016 01:51 AM |
![]() |
mahfuz19 | Excel | 3 | 03-13-2014 10:37 AM |
![]() |
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 |