Why won't this formula work to look up the maximum value in a column on another sheet?
=VLOOKUP(MAX('J-A'!$AB$18:$AB$119),'J-A'!$AB$18:$AB$119,1) This returns #VALUE. (The subject column contains calculated values. Does that present a problem?)
I tried using a simpler example on a list of simple numbers on the same sheet:
=VLOOKUP(MAX(J35:J47),J35:J47,1) This always returns the last random number in the column