I have an Excel sheet where I need to track completion progress. On Tab 1, I have a data that will constantly change (will be copy and pasting data from a downloaded report) but the number of columns and rows will stay the same. Each name in Column A is given a score for each module and there are 17 modules in total. On tab 2, I want to look up a name in tab 1 and return a count of the 17 modules that does not contain the text "N/Ans" and make it a %. On tab 1 I can get this information by using =(COUNTIF(B2:R2,"<>*N/Ans*"))/COUNTIF(B2:R2,"*"), as this sheet will be copied over whenever new data is available, I want to do some sort of VLookUp in tab 2 to return the same information. Is that possible? I've added screenshots below to help clarify.