I have to collate information from advisors within the call center i work. who call on various projects
I have set up 1 main page with separate tabs with each project, id like to download project call data and paste it into the relevant tab and the information auto fill on the main page
Currently i have
=SUM(VLOOKUP($C31,'Belgium Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Canada Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'France Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Greece Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Ireland Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Italy data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Portugal data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'Spain Data'!$A$3:$M$75,4,FALSE)+VLOOKUP($C31,'UK Data'!$A$3:$M$75,4,FALSE))
i have a feeling i am getting #N/A because the specific advisor may bot be calling on a particular project so it is unable to find that person . as calling on a project may vary day to day i cant set formula to read specific tabs hence including them all in the formula .
I have a feeling its something very simple im missing . havent attached a spreadsheet as yet, but can if one is needed
and many thanks for any help
Bookmarks