In columns B through F, I have VLOOKUP formulas that access another page in the same workbook. I have tried MAX and MAXA formulas to populate the largest result in column G. The MAX/MAXA formulas only show the result of 0
example
cell B1 is VLOOKUP(A1,'TAB1'!A:C,3,0) which results in 100
cell C1 is VLOOKUP(A1,'TAB2'!A:C,3,0) which results in 120
cell D1 is VLOOKUP(A1,'TAB3'!A:C,3,0) which results in 90
cell E1 is VLOOKUP(A1,'TAB3'!A:C,3,0) which results in 130
cell F1 is VLOOKUP(A1,'TAB5'!A:C,3,0) which results in 150
my MAX formula in cell G1 is =MAX(B1:F1) which I figured would result in 150 but it actually results in 0 and that makes me cry
I have also tried =MAX(B1,C1,D1,E1,F1) and both ways using =MAXA. The fact that I am using this formula across several columns versus rows should not impact this should it?
I feel like this is so simple that I am missing something way to obvious to see, please help
Bookmarks