On my excel spreadsheet, I need to check if Column A contains the value "check" and if Column B contains the value "900" and/or "1185". If Column B contains either value, I want those values displayed on Column C.

This is the code I used, but it does not work:

```=IF(AND(ISNUMBER(SEARCH("check",B4)),ISNUMBER(SEARCH("900",C4))),ISNUMBER(SEARCH("1185",C4))),C4,"N")
```

I need to use the ISNUMBER formula and not the "=" formula because "check" is just a part of the value in Column A. The actual value in Column A is something like this: "Example CHECK #3248". So I need to use the ISNUMBER. Column B only contains numbers. So only something like "900.00" for each line.

I am not sure what syntax I'm supposed to use or how to correctly write this. Can someone please help me with this code? Thank you

Apr 5, 2022 in Database 432 views

## 1 answer to this question.

If you're looking for the string CHECK in cells in column A, you can use the following formula:

```=IF(AND(ISNUMBER(SEARCH("CHECK",A4)),OR(B4=900,B4=1185)),B4,"")
```

• 23,260 points

## How to check if a table exists in a given schema

Since you havent mentioned the DBMS in ...READ MORE

## How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

need the row/column combinations marked with an ...READ MORE

## Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE

## Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

## Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

## EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

That's a great question, and it's a ...READ MORE