Dear All,I would appreciate if anyone can help me with matter in the attached file i would like to search through column B starting from row 11 through row 1777 i would like instead of opening the search window (Ctrl+F) i would like to have a cell or a search box where i could add a specific number and with hitting the enter it would locate the searching value
Thank you for your help
Hi, welcome to the forum
So, when you find what you want, what do you then want to do?
=MATCH(""&F2,$B$11:$B$1777,0)
will return the 1st row in the table that contains the match
=MATCH(""&F2,$B:$B,0)
will return the row number of the match
=INDEX(C11:C177,MATCH(""&F2,$B$11:$B$1777,0))
will return the relevant info, based on the search, from column D
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you and appreciate your help the only methodei wantis to enter the value cell of B11:B1777 in the cell F2 and click enter only to locate the searching value or number same methode as when i open the window for the search option Ctrl+F
i want this because it is more easy for our work to immediately add the client number in the cell and click enter insteadof opening the window of search
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks