How about a formula
      
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
 


From: Shankar Bheema 
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ code for search

Hai all good evening

I am attaching the excel sheet which contains file numbers and names in 
corresponding file number.  I placed an userform with file no. and name with a 
command button for search.   

If we know the name and dont know the file no. by giving little part of the 
name and if pressed on the search button it should show the file number and 

if we know the file number and dont know the name by giving the file number on 
the corresponding textbox and pressing the button it should return the name of 
the employee

pls suggest me the code
-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to