This is a simple Vlookup code that is using an employee number located on S10, and looking into a sheet AHT to bring me back the results on column 7.Please Login or Register to view this content.
So far so good,
But now my client is sending me a sheet where S10 may appear multiple time on the AHT sheet.
i want a formula that will bring me 1 result, and this result needs to be the average of all occurences.
So, take all the results, average it, and give a results. all the references will be numbers.
I know i can use index or small, but unsure on how to use that if its really what i need to do.
Bookmarks