Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2023, 12:13 PM
LearnerExcel LearnerExcel is offline Exact Search required as per Search Box input Windows 7 32bit Exact Search required as per Search Box input Office 2013
Advanced Beginner
Exact Search required as per Search Box input
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Exact Search required as per Search Box input

Hi,



The following code retrieves data but not the exact match. For example, if I type "C4" in F2 Cell, the result retrieves data related to C4, C41, C42 instead of just C4. Removing "*" in code didn't work.

Code:
=VLOOKUP("*"&F2&"*",ProjectData,4,0)


Search Box Cell reference is "F2".

Please support. This code is from one of the online tutorial which is I am trying to create for my own data.

Please support.
Attached Images
File Type: png Screenshot 2023-01-26.png (43.0 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exact text search in a range of cells Reyaaz Excel 5 01-17-2023 01:43 AM
Partial input text to work in auto search filter... LearnerExcel Excel Programming 2 03-10-2018 04:31 PM
Exact Search required as per Search Box input How to avoid find.execute moving focus and restore exact view after search diracsbracket Word VBA 3 10-30-2016 03:17 AM
Exact Search required as per Search Box input Help required with Selection.Find to search a text file. Marko Word VBA 2 10-18-2014 06:32 AM
Exact Search required as per Search Box input Insert input box into macro to allow user to define search term Hoxton118 Word VBA 3 05-19-2014 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft