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, 2022 in Database by Edureka
• 13,640 points
139 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, 2022 by gaurav
• 22,940 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
2,031 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, 2022 in Database by Edureka
• 13,640 points
962 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, 2022 in Database by gaurav
• 22,940 points
935 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, 2022 in Database by gaurav
• 22,940 points
693 views
0 votes
1 answer

Remove duplicates within a row

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

answered Mar 15, 2022 in Database by gaurav
• 22,940 points
125 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP