How does one cross compare data in Excel? For instance, if you have a table of data (product codes along with the quantity and names for each product for instance), and they need to be classified into 5 product classifications: Lets say you have the product codes for the five classifications—there are several codes that match each of the five classifications, but the codes are not necessarily sequential. You need to take that coding system and apply it to the total list of products, and have Excel spit out a Classification Number for each of the codes (for instance, 1 if the product code fits a code in Classification 1, 2 if the product code fits a code for Classification 2, and so forth). From there, the task is easy—I just sort based on the classification code that Excel produces, and then I can calculate the total number of products in each classification. I just can’t figure out how to cross compare the coding system with the data.
VLOOKUP() may work.
LOOKUP() if the data being referenced is sorted ascending.
INDEX/MATCH() could work.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks