Finding Macthed Values

[Wit24]

Hey guys.

I need help with the following:

I want to match certain values in the correct order in Sheet 1, as I type/search in M&P MATCH SEARCH Sheet.
The results must be highlighted from 1M to 1P or in whichever row of M&P's. Where I can filter through the results found.

Note the values M&P will be filled from cell B2;AD10000. See attached workbook.

I hope I have explained it clearly. Thank you very*much in advance*for your help.

Regards

[bebo021999]

Where do you want to put the outcome?
What the outcome look like?
Input some manual outcome where it should be.

[Wit24]

Hey bebo021999,

The outcome must be highlighted in Sheet1 so that I can filter through the outcome. I'll manually enter the Input of the outcome I'm looking for in the M&P MATCH SEARCH Sheet.

[Wit24]

Hey bebo021999.

Any luck with finding a solution?

[bebo021999]

Is it are you looking for? See attachment.

[Wit24]

Yes, almost something like that but I think it needs some fine-tuning.

It must look in all the columns from 1M;1M;1P;1P until 5M;5M;5P;5P for the same outcome in the same order as in the M&P MATCH SEARCH Sheet.

I did some changes to the attachment in the M&P MATCH SEARCH Sheet by removing the last value P in E1 and the outcome comes incorrect. Please assist me with this,

[Wit24]

Hey bebo021999.

I'm still struggling to get a solution.

[Wit24]

Hello

Can someone please help me with a solution?

Regards

[Wit24]

Hey guys, can someone please help me with this?

Regards

[JohnTopley]

Just copy the CF from the IM:1P and change the ranges so B:C becomes H:I and D:E becomes K:L for 2M and 2P respectively.

[Wit24]

Hi John

Thank you for helping me. If you remove the value in E10 on the M&P MATCH SEARCH Sheet, it doesn't highlight all the values in Sheet1 as in the M&P MATCH SEARCH Sheet, that's the problem I'm having.

[JohnTopley]

Mu understanding is that the "pattern" in Sheet1 should correspond EXACTLY with one in M&P MATCH SEARCH. Deleting any character in M&P MATCH SEARCH will mean the Sheet1 pattern will not match.

If the changed M&P MATCH SEARCH is copied to Sheet1 then it will be highlighted in M&P MATCH SEARCH sheet.

[Wit24]

My goal is to get all the patterns highlighted in Sheet1 as exactly what I enter into the M&P MATCH SEARCH Sheet.

[JohnTopley]

The M&P MATCH SEARCH does not know which pattern from Sheet1 has been selected and therefore cannot match (the unknown).

The highlighting only occurs when the patterns in both sheets match i.e are identical cell by cell: and that does work.