I am trying to VLookup a column (Sheet 1, A) to find the highest number. Is
there a way to do this? I don't want to use auto filter.

Greg