Greg,

Use the MAX function in your VLOOKUP. SOmething like this untested one:

=VLOOKUP( MAX(A2:A30), Table, ColumnToReturn).

You could also sort the table, descending, on column A. That'd put the
highest one at the top of the list. Sorting a table for convenience on some
particular column is a perfectly acceptable thing to do, as long as you're
familiar with Excel's sorting mechanism, and its dangers.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"gregork" wrote in message
...
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