Pooja, I hope you are looking for this one..(colored in red) this was calculated as per the length..so you can adjust the same per your convience...
Good Luck Cheers Surya On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma <vatspoojav...@gmail.com>wrote: > Hi All, > > I need a help, with a condition in which I have to match a column with > other two columns and if out of those two columns any of them match with the > first column then the result will be "Match" otherwise "Mismatch" > > -- > Best Regards > Pooja Sharma > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Helpl required on condition or formula.xls
Description: MS-Excel spreadsheet