LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 137
Default vlookup in reverse search direction

I've found VLOOKUP only to be reliable when the lookup table is sorted
prior to the lookup (giving the same result as you mentioned).

If I understand your problem, your REP table needs to be sorted before
the VLOOPUP with work correctly.

 
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
reverse cursor/text direction within cell [email protected] Excel Discussion (Misc queries) 4 August 24th 08 06:12 AM
Find - search in upward direction RobN[_2_] Excel Discussion (Misc queries) 4 July 14th 07 02:17 AM
How do I reverse the direction of the tab key Nathan Crump New Users to Excel 2 July 11th 06 02:21 AM
How do I do a Reverse Find/Search in Excel? NumberDocc Excel Worksheet Functions 2 February 27th 06 10:55 PM
Reverse Direction of For-Each-Next? FuzzyDove[_2_] Excel Programming 2 November 23rd 04 11:18 PM


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