array formula

Thank you so much for your assistance!

Sadly I need more assistance on this.....

I showed the outcome to my peers and they came back with requested enhancements to "put it up a notch"

I am not even sure if it can be done.... Ive attached the working SS.

The enhancements I need to make are as follows:

1) On the results tab, I need not only the description ( pulled from the results key tab) but also the cost as shown on the results key tab column E.

2) I need to know if there is a way to include a new search function to exclude a wellness code or codes. Currently on Data information B5 the code narrows down to include only that code. Is there a way to do the reverse ie exclude only that code.

Perhaps it would be easiest to have those codes pull a result onto a seperate tab which would then be the new results key.....

3) Does anyone know if there is a form that would allow me to customize how the results tab looks?

I know this is all pretty overbearing and possibly confusing so maybe we can tackle then one by one...


Just as background, the wellness profile is the source data. This pulls to the results key to form an index which is narrowed down from the data information tab lines B4 and possibly B5. The end result is on the wellness results tab.

Its a pretty neat workbook (Thanks again Morrigan!) that apparently needs to be "amped up".

Try this, I had to add a helper column to make things simpler. You will have to do some formatting. As of now, it does not look very professional~


HTH