EXCEL How to check if Column A contains specific value and Column B contains 2 specific values

0 votes

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 by Edureka
• 9,320 points
28 views

1 answer to this question.

0 votes

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,"")

enter image description here

answered Apr 6 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer
0 votes
1 answer

How to check if a table exists in a given schema

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

answered Oct 4, 2019 in Database by Daric
• 500 points
1,847 views
0 votes
0 answers

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

Feb 24 in Database by Edureka
• 9,320 points
28 views
0 votes
1 answer

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

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

answered Mar 15 in Database by Edureka
• 8,820 points
42 views
0 votes
1 answer

Remove special characters from the specified string in excel

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

answered Mar 15 in Database by Edureka
• 8,820 points
51 views
0 votes
1 answer

Remove duplicates within a row

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

answered Mar 15 in Database by Edureka
• 8,820 points
34 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP