Hi, have done some research on this, but can't find the answer.
I'd simply like to create an average of three numbers (each between 1 and 10), which are located in columns V, AJ and AX of my sheet, and for the average to be returned in column AZ. The only issue is that the numbers in V, AJ, and AX are the results of a vlookup from another sheet, so a simple =average (V1, AJ1, AX1) won't suffice.
How can I create an average when the vlookup formula is still in the relevant cells?
I feel like it's an averageif, but can't quite get my head around it.
EDIT: attachment provided, although figures needed to create the average aren't correct due to sensitive nature of vlookup formula file location. Hope this is enough to understand!
Thanks.
Bookmarks