search function

  1. J

    Search through a column

    Hey All - newbie to the board and to macro programming, but not to programming in general. I'm currently trying to improve a macro that someone else wrote. It takes two lists of people (one old, one new), finds the matching entries by comparing ID numbers, then records any changes that have...
  2. M

    if + search

    Hello! I'm trying to write a formula and think I'm about halfway there. Here's what I have so far.... =IF(ISNUMBER(SEARCH("52100",A43)),"brand a",IF(ISNUMBER(SEARCH("00703",A43)),"brand b",IF(ISNUMBER(SEARCH("21500",A43)),"brand c",IF(ISNUMBER(SEARCH("36200",A43)),"brand...
  3. S

    Complete search

    :confused:<TABLE style="WIDTH: 425pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=565 x:str><COLGROUP><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL...
  4. R

    Unable to get the Search property of the WorksheetFunction class.

    I am having trouble with IsError function consistently catching errors in my call to the Search worksheetfunction. For example, here is a snippet of my code that works just fine: If IsError(Application.WorksheetFunction.Search("__*-DEFERRED", netName)) Then If...

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top