Hello Experts,
On the attached file. I need help to write a formula on the sheet name "Score" that will look for the meat name and the corresponding month on the sheet name "Data" and return the number that is in the TKT Avg column. Note that the TKT Avg column is found at every 4th column Please see example i have done for the month Jan-10. The formula i use cannot copy across to the other months. So the formula i need should be able to copy across to the other months
Thanks,
Teddy
Bookmarks