min/max numbers from vlookup

[gtd526]

Hello,
not getting min/max from vlookup values.
v56 & 57 are from vlookup
v58 & 59 are entered manually
min/max not working with vlookup values???
they have a number format.

thanks

NFL.xlsm
	V	W
56	-5.1	8.3
57	8.3	8.3
58	-5.1	-5.1
59	8.3	8.3
Weekly Picks

Cell Formulas
Range	Formula
V56:V57	V56	=VLOOKUP($A4,ProFootball!$H$4:$S$45,12,0)
W56,W58	W56	=MIN(V56,V57)
W57,W59	W57	=MAX(V56,V57)

 

[gtd526]

Hello,
not getting min/max from vlookup values.
v56 & 57 are from vlookup
v58 & 59 are entered manually
min/max not working with vlookup values???
they have a number format.

thanks

NFL.xlsm
	V	W
56	-5.1	8.3
57	8.3	8.3
58	-5.1	-5.1
59	8.3	8.3
Weekly Picks

Cell Formulas
Range	Formula
V56:V57	V56	=VLOOKUP($A4,ProFootball!$H$4:$S$45,12,0)
W56,W58	W56	=MIN(V56,V57)
W57,W59	W57	=MAX(V56,V57)

Im good. I had to format another sheet.