LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default comparing 2 sheets

Peter Atherton wrote:

Just a point when using VLOOKUP the parts must be arranged
in alphbetical order. If they are not sorted then MATCH
needs to be included in the formula.


No it doesn't, that's what the fourth argument is for, 0 = not ordered,
1 = ordered.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

 
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
comparing 2 sheets rodchar Excel Discussion (Misc queries) 2 May 20th 09 03:38 PM
Comparing 2 sheets PauloG Excel Discussion (Misc queries) 5 May 13th 08 12:47 PM
Sheets comparing Saed Excel Worksheet Functions 1 April 1st 08 07:21 AM
comparing 2 sheets rodchar Excel Discussion (Misc queries) 3 September 11th 07 03:55 AM
comparing sheets Lorenzo Excel Programming 2 August 12th 03 02:22 PM


All times are GMT +1. The time now is 11:09 AM.

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"