Thread: Exact Search required as per Search Box input
View Single Post
 
Old 01-25-2023, 12:13 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2013
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
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, 4 views)
Reply With Quote