title: IF Statement on Range Of Cells
body: <p>I have a range of cells that I would like to look at with this if statement.  I basically want this formula to look at the "Customer" and then look at a list of Customers that provide their own routing, if that "Customer" is on that list (in that range of cells) then i would need for the formula to return a "Y" for yes and if they are not on that list then i just need an "N" for no.  I've included a picture.  Then range of cells that it needs to look at is G10:G28.<img src="https://i.stack.imgur.com/HrOk8.jpg" alt="example"></p>