Non-sequential VLOOKUP function -OR- sequential sort of web query
 

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

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
.