IF(ISERROR and Match not working when trying to match a cell to a value in a column

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?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,275
Messages
6,171,123
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top