Hi Mahesh, I was not able to open your file since I'm with Excel 2003. Please, could you save as 2003 and re send? If you can have sheet 1 sorted ascending, I think that you could use Vlookup without "TRUE" argument at the end.
Thanks, Chechu On Sep 5, 4:07 am, Mahesh <mahender.bi...@gmail.com> wrote: > Dear Firends, > > need ur help here. > > i want to enter number in sheet 2 and want to match it in sheet 1 > if the same number is not in the sheet 1 then it will find the nearest > number either +1 or -1. > > Please check the attached sheet. > > -- > With Love, > Mahesh Bisht > > Book1.xlsx > 15KViewDownload --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
