Hi all, first post - thanks in advance for taking the time to take a look.
I've looked and looked for an answer to my issue but no luck, hoping somebody can please help.
My file looks like below but with 65k rows.
<tbody>
</tbody>
I want to search for a hotel using multiple search terms and return row number or potentially highlight any row that contains all words exactly (don't want case sensitivity). Also, as I will be repeating this process I want to define a named range and enter the search criteria into the sheet rather than changing the formula each time as below.
<tbody>
</tbody>
As above, search terms are "hilton" and "new york" so I want to return row 3 from the data file. I do not care about rows 4 or 5 that contain only one of these values (Hilton/New York).
As in example above with "The hilton", I cannot simply use Ctrl-F as hotel names are not exact - "Hilton New York" does not appear in a single cell. As per other examples given, hotel name may or may not contain location and doesn't have a set standard! Of course
Using Office2010 if that helps, hopefully above makes sense.
Regards, B
I've looked and looked for an answer to my issue but no luck, hoping somebody can please help.
My file looks like below but with 65k rows.
Hotel Name | Location |
Best Western | Washington |
The hilton | new york |
Intercontinental the Barclay | New York |
Hollywood Hilton | hollywood |
<tbody>
</tbody>
I want to search for a hotel using multiple search terms and return row number or potentially highlight any row that contains all words exactly (don't want case sensitivity). Also, as I will be repeating this process I want to define a named range and enter the search criteria into the sheet rather than changing the formula each time as below.
Search Criteria |
hilton |
new york |
<tbody>
</tbody>
As above, search terms are "hilton" and "new york" so I want to return row 3 from the data file. I do not care about rows 4 or 5 that contain only one of these values (Hilton/New York).
As in example above with "The hilton", I cannot simply use Ctrl-F as hotel names are not exact - "Hilton New York" does not appear in a single cell. As per other examples given, hotel name may or may not contain location and doesn't have a set standard! Of course
Using Office2010 if that helps, hopefully above makes sense.
Regards, B