Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Function Not in Ascending Order | Excel Worksheet Functions | |||
How do I # my rows in ascending order. | Excel Worksheet Functions | |||
Digits in ascending order ? | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) |