In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded.
I m giving the picking values for customer codes and locations from user defined data.
The problem is how to get the Values lying in the cells at intersection of those customer codes and locations.These values then will be returned in one row.
Thanks in advance for giving me the logic to sove this problem
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!