Need a formula that can check multiple criteria and return a value.

Thanks for the quick responses. What I am looking for is a code to say here is id number 16589, it is a group, it consist of models Davolio, Fuller , and Peacock, the price for those models in that combination is $300. Hope this clears up the confusion thanks again.




group-single.xlsx

I posted a second workbook with that information in it like you asked for the first time, so I am not sure what you are asking for.

Thanks for the help.

Ok I think I follow you, how is this ?

On the Chart Tab

1--look down the "ID" column and match the id's:
What I mean is match the ID's to each other on the CHART tab and in the ID column.If you have 16580, 16589, 16590 etc in the ID column on the CHART tab then the code finds all of the 16589 id's in the ID column on the CHART tab to begin making the model set.

2--look at the "Type" column to decide whether it is a "single" or "group":
This information is default information this is how the model sets are defined. The information will always say "group" or "single" and the ID sets will always be one or the other.There will never be one ID number with both "TYPES" listed. I need the code to look at the TYPE column and reconize if it is "single" or "group" to continue in making the Model set.

3--look to "Model" column to see what models are used with the same id's:
Once to this step the code should have created the model set by using the id numbers in the ID column on the CHART tab and determined whether or not the model set is a "group" or "single" from the TYPE column on the CHART tab. This way the code knows what model set it is looking at. Example: Davolio, Fuller, Peacock this set all have the same ID number from the ID column on the CHART tab and are all listed as a "group" in the TYPE column on the CHART tab.

On the Combo Tab

4--check a seperate tab "Combo" with a list of models and price:
This step is checking the model set that has been created in the first three steps and checking it against the listed model sets on the "Combo" tab to get the price for the created set from the PRICE column on the COMBO tab.

On the Combo and Chart Tab

5--return the listed price for the particular "model set" from the "Combo" tab to the "Price" column

This is the final step where all the previous steps come together. If done correctly the id numbers from the ID column on the CHART tab should have been matched up so that there is a complete model set to look at, the type of model set being created should have been defined as "group" or "single" from the TYPE column on the CHART tab, and the price for that model set should be known from the PRICE column on the COMBO tab, leaving the last part of returning that price from the PRICE column on the COMBO tab to the PRICE column on the CHART tab.

Hope this helps

Thanks for the help.

Just wanted to bring this back up and see if any more information was needed or if it is possible to do.

Thanks for the help.

Is there a way to combine the following 3 formulas to get the results I am looking for?

=IF($A$2:$A$10,$A$2:$A$10)

=IF(C2=" Group", TRUE,FALSE)

=VLOOKUP(B2,Combo!$A2:$E19,5,FALSE)

Thanks for the help.

Brendan,

First thanks for taking the time to even give this problem a try. Your code is a good one but will not work with what I want to do as I cannot add the ID numbers to the combo page. As you stated in your response "given that your query has had in excess of 200 views and only 2 people have tried to help you..." I am going to just take it as this cannot be done and mark it as solved. Again Thank You very much to all those that even attempted to try this your hard work and time was greatly appreciated.

Thanks for the help
DeeJay