Chart with different qualifications

See the top banner for how to attach a workbook. Populate it with just enough information to demonstrate the functionality. In this case, two or three insurance companies.

Without seeing the criteria it would be difficult to design the logic. For example in type vehicle, a company may accept sedans, SUV and Trucks. So in the vehicle type field you can have Sedan,SUV,Truck and the formula =ISNUMBER(FIND(Vehicle_Type,"Sedan,SUV,Truck")) will be true if the vehicle_type is one of the three. If it is, say, "Motorcycle" then it would yield FALSE.

Thanks for the help. I did not have much of a workbook created per say since I did not know where to start. I ended up creating various charts for every question that used vlookup and then using some formulas, some including the formula you suggested but I am now pretty deep in the process but I hit a snag. I have the following formula:

Formula:

Please Login or Register  to view this content.

The text contained in the referenced cell "Guidelines!D8" contains the following values:
2,3,4,6,7,8,10,11,12,13,14,15,16,20,22,23,25,26,27,28,31,32,33,34,35,36,37,38,40,41,42,43,44,45,46,48,49,50

The issue I am having is that I am trying to avoid the number "5". As you see, "5" is not an option in the values on that cell, however "5" is part of "15", "25", "35","45",and "50".

The formula triggers a "1" or True since it detects the number "5" in the that cell but being part of "15", "25", "35","45",and "50" but I want it to come back as "0" or false because "5" is not an option in the list as a whole.

I attached a sample Excel for reference purposes. The cell with the formula is in KeysCarrrier!C13

Perhaps the following would work:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.