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

[Guest]

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

 

[Jason Morin]

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