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 in Database 35 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,"")
```  answered Apr 6 by
• 13,560 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