Modifying a current index match and making it more dynamic.

Hello -

I currently have the following formula

Please Login or Register  to view this content.

What it is doing is based on a zip code input pulling a subsidy rate associated. It currently works as expected and needs to remain functional. However, I need to do is add a bit of complexity to it. I'm hoping someone can help.

Cell C8 is a field that is used for the user to enter their zip-code

X15:X22 - 93620, 93635, 95301, 95340, 95726, 95945, 95949, 95959, 95975

If C4 equals "EE_Only" and C8 equals X15:X22 than I should get "404.67". If both of these criteria are not meet the referenced code should run.
If C4 equals "EE+Spouse" and C8 equals X15:X22 than I should get "832.41". If both of these criteria are not meet the referenced code should run.
If C4 equals "EE+Child(ren)" and C8 equals X15:X22 than I should get "624.81". If both of these criteria are not meet the referenced code should run.
If C4 equals "EE+Family" and C8 equals X15:X22 than I should get "1139.54". If both of these criteria are not meet the referenced code should run.

Any help is greatly appreciated.

Are you saying "if C8 = any value in X15:X22" or "if C8 = all values in X15:X22" (that is, X15:X22 are all equal to C8)?

This is untested, since you didn't provide a workbook, but perhaps:

Please Login or Register  to view this content.

A small sample workbook (NOT a picture) would help us to solve your problem quickly and accurately.
Remove any sensitive or extraneous info, we just need some “realistic” data for testing purposes.
Please include examples of any variations the code or formula must address.
Also, PLEASE simulate some results to demonstrate what you want.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!

Let me know if you need further help (preferably with a workbook to test ). If your problem is in fact solved, please go to Thread Tools up top and mark your thread SOLVED. Thanks! -Lee