if find text

  1. J

    Excluding a Cell range from a selection in a drop down list

    Hi All, I currently have a budget sheet where when i select a customer from a drop down list, the ratio will calculate and change the result to show the overall profit as per selected customer. The client was created by a data validation list and the ratio through a xlookup. The ratio in...
  2. N

    Formula Needed for: FIND "YES" and Return in same cell as YES

    Hi MrExcel Community, See below for a sample of data that I need to extract information into a searchable database. All of the information is provided in both columns and rows. I'd like to create TABLE 1 into TABLE 2. What's most frustrating is identifying project type by finding the YES and...
    • NTCICmac
    • Thread
    • extraction if find text same cell vlookup vlookup & data validation
    • Replies: 4
    • Forum: Excel Questions
  3. 1

    If statement help please

    I am trying to get the below formula to work and get a #VALUE error. I am trying to check one cell "M4" for a specific text. Thanks in advance for your help. =IF(FIND("CHAMFER",M4),0.25,IF(FIND("FINISH",M4),0.25,IF(FIND("MACHINE",M4),0.25," ")))

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