Hi, I'm working on a project that needs to have a product returned based on a ranking order which I have in a lookup table.
I'm showing below I have 3 records. Each can have up to 20 products but I only need to return the highest ranked product per record. Here is the ranking of the products in Lookuptable1 1 - ABC 2 - PQR 3 - XYZ 4 - DEF 5 - MNO Here are 3 sample records with the Cols being my header row Col1 Col2 Col3 Col4 ABC XYZ MNO PQR XYZ DEF DEF MNO Which should return these products based on the ranking order ABC PQR DEF I need a script written that will look at all the columns and only return the highest ranking product in each record. I've tried to make this as clear as possible, Hopefully, I haven't overcomplicated it. I usually waste a lot of time in excel sorting to get my end result and I'd like to figure out how to accomplish this in fusionpro to make my life a lot easier. Thanks in advance Lisa +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
