isnumber. find

  1. M

    Multiple Criteria

    Can you see if you can help me with this Excel issue, What I am trying to do is:- If the value in column D is in column C then output the corresponding column E value into Column A. I have tried using the formulae which is in cell A2 but when I copy it down nothing happens?? Image attached...
  2. M

    IS NUMBER SEARCH with TWO conditions

    Hi I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell. In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1. The formula I have used is...
  3. W

    Macro Troubleshooting---Multiple Ifs

    <tbody> A B C Tests 410--Troubleshoot Test 410 Troubleshoot Test 873---Water Pressure Test Water Pressure Test 873 </tbody> Hello, The problem I'm having is that I have a column (Column B) of about 30 different tests that are...
  4. M

    Stumped on Excel Formula and Grateful for Help

    I have an excel file that I am trying to do a calculation only if value of 'Closed" isn't present in another cell. Closed is a status I'm using in a drop down. Trying to calculate if "Met SLA" or 'Did Not Meet" only if status closed is not included, I think I need to consolidate a Search and...
  5. L

    Index Match with partial match

    I Have an extensive spreadsheet, with very long text cells: Content Spreadsheet with cells like: (about 20.000 lines) 1. Complete/Long Manufacturer Name 2. Complete/Long Product Full Description 3. Lookup columns to be added: [*=2]Part Number [*=2]Type of Product [*=2]Classification...
  6. T

    Using nested "if(or(isnumber(search.." to search in a string for text and return a value

    I am trying to build a nested formula that will search in a url string for a set of keywords and return a label. I have tried several different ways of doing this and have not been successful. Here are my attempts. Thanks in advance for any assistance on this question...

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
Back
Top