multiple or criteria

  1. N

    Search Text in Multiple Columns and Return Value from Multiple Columns

    Hello, I am trying to return values if either criteria is found in the item description. For example if the text in Column G is found in Column A then I want the value in Column H to return; and if the text in Column I is found in Column A then I want the value in Column J to return...
  2. N

    Index Match with "Or" Criteria and Search Text

    Hi! I am trying to return an item name if either criteria is found in the item description. Column B has the formula that I am currently using to accomplish this, and although it works fine for this example, it is way too long in my real data set and is an obstacle when more items needs to be...
  3. N

    Index a table of data based on either 1 of 2 critria

    Hi We use a stop card system to report safety observations. I made a small statistics excel sheet to monitor the progress of closing out those cards. the cards have three status' open, closed or in progress within the worksheet. On the same worksheet I want to create a second table that...
  4. S

    MIN based upon multiple OR Criteria

    I would like to find the MIN date in Column C if EITHER col A="a" OR col B="x" COL A COL B COL C A Y 12/12/2014 Q X 10/11/2014 B Z 10/10/2014 In this case, the MIN...
  5. S

    MIN based upon multiple OR Criteria

    I would like to find the MIN date in Column C if EITHER col A="a" OR col B="x" COL A COL B COL C A Y 12/12/2014 Q X 10/11/2014 B Z 10/10/2014 In this case, the MIN...

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