return min value in vlookup

Originally Posted by meweaver27

thanks a lot! Big help! I think it was not working for me becasue i switched it on my real sheet to lookup an entire column A:A rather than a range from A1:A1235

It will not work with an entire column, the maximum you can use is A1:A65535