Excel IF Range Contains Value | How to Perform an IF Statement on a Range

In this video I demonstrate how to create an IF formula that performs a test across a range of values rather than a single value.

In the first example, I look to see whether a name is found in a list of names and in the second example I evaluate whether a numeric target has been met within a range of numbers.

The functions featured in this video are: IF, MATCH, COUNTIF and ISNUMBER
------------------------

[xkaliba]

thank you much for this vid you've helped solve two major headaches I was having with my project (the other was the vid about returning a blank for a 0 value) consider me a subscriber !!!!

[martinbuckland]

hi there, can you run 3 IF statement's at the same time in the same cell?

[sidneydanielgomezbriceno]

Thank You. I was stuck on a race car vehicle dynamics program right now, you helped me move forward for school. Cheers mate!

[IvanCortinas_ES]

Thank you for this explanation Chester. As always, excellently detailed!

[abudaem]

Thank you Chester, this explanation meets my need exactly

[PhilipKearney-sz]

This formula won't work in a row range as nothing is happening for me when I used the same formula but in a row rather than a list in a column, any ideas?

[obscene]

What if I'm trying to do a partial match with hundreds of potential partial matches? I have a long list of partial strings in $K$28:$K$400, and I want to see if any of those cells are a partial match to $D5. Been searching online all week but cant find anything? Any suggestions?

[MdWstMan]

How do you give it a range? Let's say I want to count the number cells have a number between 5-5.5. How do I set it to count all the numbers in that range?

[thewanderer]

is there a formula that will search a set of cells for a specific text, and if the text is found, will produce the corresponding text in the cell next to it?

Sort or like a match formula that would find data, and output data from another cell next to it. For example, say your data in your video, the attendees also had an age column to the right. I want the formula to search the data to see if a Bob attended, and if so list his age in the column to the right. If not, produce a dash.

So like a match formula and an if/then formula together.

[rasadurrahman]

I have a query please!!!! Let me share, say, in excel i have a column with 100 data. 50 data is used for one formula and other data for different formula. When i used 1st cell for using formula and when completed i scrolled it down but all cells(100) data used for 1st cells formula but i want to fixed that downward up to 50 data, , solution

[anil]

How to enable macro settings before file open and disabled after file closing

[NCS-TRV]

Can you help determining if date range includes weekend or holiday (ie, date1=[order start] & date2=[order completed]? End goal is to use the "true or false" result to later determine actual turn time hours (less weekend/holiday) in another formula.

[mgfilmsentertainmenthindi]

Hai, Nice Video. I need one formula condition. For an example: A and B two columns different values only sum 1+2=3 and same values only showing single value 4, 4 = 4 . It is possible please send formula.
A B
1 2 = 1+2 = 3
2 6 = 2+6 = 8
4 4 = 4, 4 = 4