If you set the 4th argument in VLOOKUP to 0, then the
data you are querying does not need to be sorted.
HTH
Jason
Atlanta, GA
-----Original Message-----
I'd love to see a VLOOKUP function in the next version
that does not require
the reference data to be in sequential order. I've been
using web queries to
pull real-time stock market data (OK...1 minute delay)
from my on-line broker.
The data they stream often includes a value or two that
is out of order,
making it impossible to make VLOOKUP work for this
purpose. I tried to
include a sort of the array, to no avail, as it will not
update with web
query.
I guess another option would be to include an option to
perform a sequential
sort on the web query before it posts to the spreadsheet.
I sure do love the web query feature. I think it is one
of the best
improvements to Excel in years !
- Eric C. Swansen
Ski Bum Emeritus, Jackson Hole Wyoming
Microsoft Investor
.
|