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: 37
Default lookup or vlookup

Hi
I have this worksheet

25 apple
15 banana
30 cucumber
5 tomato

If I use vlookup or lookup function, the data should be sorted, the
default of these functions is ascending or descending, but I do not
want to sort the data, any help?
Thanks in advance
Jam


 
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
Help with lookup (vlookup) davidio Excel Worksheet Functions 1 July 27th 07 08:42 PM
Help with Lookup(), VLookup phil Excel Worksheet Functions 6 February 8th 07 01:06 AM
LOOKUP or VLOOKUP MichelleS Excel Worksheet Functions 9 October 20th 06 02:11 PM
Lookup without VLOOKUP? J New Users to Excel 6 November 17th 05 06:57 AM
LOOKUP or VLOOKUP Bennie Excel Worksheet Functions 4 March 24th 05 07:45 PM


All times are GMT +1. The time now is 05:59 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"