Indirect is volatile ... and with that huge range ... I don't think that's
wise!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pete_UK" wrote in message
oups.com...
If it is sorted within each column and sequentially from one column to
the next, so that the value in B1 is larger than the value in A65536,
then a quick check of the range A1:D1 will determine which of the
columns to look down, so by making use of the INDIRECT function you
would only need one VLOOKUP down the column with a MATCH to find which
column.

Does this help?

Pete

sloth wrote:
And yes it can be sorted.

sloth wrote:
The data is in A1:D65536. The data is sorted ascending.