View Single Post
 
Old 08-19-2017, 03:42 AM
vicmar vicmar is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2017
Posts: 24
vicmar is on a distinguished road
Default

hi @NBVC

I add more sheets and I adjust the formula as per below:

=IF($A5="","",IFERROR(IF(COUNTIF(CV!$F:$F,$A5&"_"& 0),INDEX(CV!C:C,MATCH($A5&"_"&0,CV!$F:$F,0)),INDEX (CV-SKT!C:C,MATCH($A5&"_"&0,CV-SKT!$F:$F,0)),INDEX(AR!C:C,MATCH($A5&"_"&0,AR!$F:$ F,0)),INDEX(LS!C:C,MATCH($A5&"_"&0,LS!$F:$F,0)),IN DEX(EL!C:C,MATCH($A5&"_"&0,EL!$F:$F,0)),INDEX(ME!C :C,MATCH($A5&"_"&0,ME!$F:$F,0)),INDEX(GE!C:C,MATCH ($A5&"_"&0,GE!$F:$F,0))),""))

But I encounter an error saying "You've entered too many arguments for this function"
Reply With Quote