I'm using the index function to lookup data from the web (web query).
Curently I'm using 4 web query's to update information (set to refresh
on opening the document). Luckily I see by hiding certain cells (heading
cells) it does not affect the data when refreshed. My challange is that
the data is not in acsending order, I know with vlookup functions this
would be a problem. How does this work with index functions. If not
mistaken I could get all in ascending order but than I will need to
split the web query's, instead of the 4 I will end up with about 40 web
query's!

Currently I usde index to lookup values in column A, B and C, when
matching it returns the price in the column 8

Thanks,

W:Bgr


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105186