Captain Smith
Active Member
- Joined
- Feb 28, 2003
- Messages
- 324
Is there a better approach than the following? Is there a way of using just one Vlookup reference instead of having to refer to eight different ones to achieve one average? Thanks.
=AVERAGE(VLOOKUP(A4,Sheet1!A20:GV20,11,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,12,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,13,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,14,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,15,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,16,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,17,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,18,FALSE))
=AVERAGE(VLOOKUP(A4,Sheet1!A20:GV20,11,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,12,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,13,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,14,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,15,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,16,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,17,FALSE),VLOOKUP(A4,Sheet1!A20:GV20,18,FALSE))