HELP - Based on "C" cell entry, Find mismatch figure in row. And save/show separately

Hi All,

I things, I am doing lengthy process…..

With the help of vlookup, I incorporate the “Master File” data in same sheet, in column “C”

The changes of the same done in revise attachment.

Regret for inconvenience

Regards

Amar K




Hi All,

Required your valuable help again……

I have massive pivoted data, and want to find mismatch entry between them.

Scenario.

Sheet1 having pivoted data, Row Number 1 is Plant range, Column “A” is material unique code. Every material code loaded with purchasing group enter. The same is incorporated in pivot. Perhaps in some plant entry is wrong.

I want to find out the mismatched entry (i.e Mat code and plant number) in new sheet or in same sheet, with the base of “Master File” spreadsheet (its store in same worksheet), the same is having correct purchasing group in column “C”

Can code will find out mismatch material code and reference plant.

Sample spreadsheet is attached for your reference.

Any help is highly appreciated

Thanks

Amar K

Refer the attached file for Pivot Table Solution With The Help Of Formula

I replaced the Index formula with Clookup UDF function in VBA module1 to get concatenated mismatching results.

Refer the attached file for details