D
daredelsol
Hello. I have two VLOOKUP formulas that give the right answer in two
cells and then I can get an average of those two cells correctly by
using AVERAGE. But, when I try to combine the two VLOOKUPs into one
cell's AVERAGE formula I get an unexpected result.
The area in the VLOOKUPs appear to not change when I am on the
individual formula as shown here:
VLOOKUP(M2,TableData,6,FALSE) = 26
VLOOKUP(M2,TableData,7,FALSE) = 46
Average of both: AVERAGE(I3:I4) = 36 correct
AVERAGE(VLOOKUP(M2,TableData,6,FALSE),(VLOOKUP(M2,TableData,7,FALSE)) =
19 incorrect
Why? and What is wrong? Thanks!!!
cells and then I can get an average of those two cells correctly by
using AVERAGE. But, when I try to combine the two VLOOKUPs into one
cell's AVERAGE formula I get an unexpected result.
The area in the VLOOKUPs appear to not change when I am on the
individual formula as shown here:
VLOOKUP(M2,TableData,6,FALSE) = 26
VLOOKUP(M2,TableData,7,FALSE) = 46
Average of both: AVERAGE(I3:I4) = 36 correct
AVERAGE(VLOOKUP(M2,TableData,6,FALSE),(VLOOKUP(M2,TableData,7,FALSE)) =
19 incorrect
Why? and What is wrong? Thanks!!!