Bundle Lookup with Calculation & Script

[pr4t3ek]

Hi,

I have a list of reference data in the tab "Reference".

For each bundle listed in the reference table, I want a script to populate in a new spreadsheet a list of all other bundles where the bundle cost is the same or higher than that current bundle and where the "other bundles" are set to "Yes" in the "Bundle Active in Future" field.

See Result for the result to the above.

Please let me know if there are any questions.

Cheers

[rylo]

Hi

Try this

Please Login or Register  to view this content.

rylo