ThePangloss
New Member
- Joined
- Jun 19, 2015
- Messages
- 40
I've got a list of names, numbers, and identifiers. I have one sheet that is perfectly sorted(Sheet1), and one that is extremely jumbled(Sheet2). I need to sort the jumbled ones to be sorted. They're both very similar. The sorted one is sorted into multiple categories, such as Category A, B, C and so on. The jumbled ones are just in a straight sheet without and categories.
What I want to do is match the three variables in all of Sheet2, to one category in Sheet1. If there are matches I'll just sort them and copy and paste them myself. Then continue down for all the categories.
So right now I have
IF(ISERROR(MATCH(K2&"|"&M2&"|"&L2,Sheet1!G2:G1000,0)), false, true)
Where columns K, M, and L are my variables in Sheet2. And Sheet1 column G has these in K2&"|"&M2&"|"&L2 form copied down through G. G2:G1000 is the first Category for example. I want to match it to anything that comes up in the whole column from G2:G1000 so I think I'd need wildcards of * but I'm not sure.
Also I get #NAME? when I do this. Any ideas?
What I want to do is match the three variables in all of Sheet2, to one category in Sheet1. If there are matches I'll just sort them and copy and paste them myself. Then continue down for all the categories.
So right now I have
IF(ISERROR(MATCH(K2&"|"&M2&"|"&L2,Sheet1!G2:G1000,0)), false, true)
Where columns K, M, and L are my variables in Sheet2. And Sheet1 column G has these in K2&"|"&M2&"|"&L2 form copied down through G. G2:G1000 is the first Category for example. I want to match it to anything that comes up in the whole column from G2:G1000 so I think I'd need wildcards of * but I'm not sure.
Also I get #NAME? when I do this. Any ideas?