#1
|
|||
|
|||
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. |
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 |
How to avoid find.execute moving focus and restore exact view after search | diracsbracket | Word VBA | 3 | 10-30-2016 03:17 AM |
Help required with Selection.Find to search a text file. | Marko | Word VBA | 2 | 10-18-2014 06:32 AM |
Insert input box into macro to allow user to define search term | Hoxton118 | Word VBA | 3 | 05-19-2014 02:03 AM |