LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default index function - ascending order


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Function Not in Ascending Order Jessica Donadio Excel Worksheet Functions 14 August 31st 08 11:04 PM
How do I # my rows in ascending order. burgos Excel Worksheet Functions 1 February 16th 06 07:13 PM
Digits in ascending order ? toyota58 Excel Worksheet Functions 2 February 3rd 06 06:47 PM
How do I lookup a value in a array that is not in ascending order John Excel Worksheet Functions 6 June 20th 05 09:40 PM
sorting number in ascending order Janice Lee via OfficeKB.com Excel Discussion (Misc queries) 2 April 8th 05 10:31 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"