Column Match

[gbfoligno]

Hi everyone!

I'm creating this macro to help me at work, but I got stuck this point, every day I receive this spreadsheet which I have to make sure Type/Model (Column A) matches Quote Line (Column B). Works like this;

When 9993005 is a Type/Model, Quote Line must be equal 0157. If Type/Model is 999E005, Quote Line must be 0156. Same for values below;

If Type/Model - Quote Line must be

DELD646 – 0172
DELN3A6 – 0169
XHWDOEM – 0190

It would be nice have a tool that could check if Type/Model matches Quote Line, just check not fix. Any Idea of what kind of formulas or conditional formats I could use?

Many thanks!

[oeldere]

With VLookup.

See the change of the blue cell.

The result is in the green cells.

See the attached file.

[MarvinP]

Hi,

See if this Vlookup and If formula will help instead of doing a macro. See the example.

[mrice]

You could try the following conditional formatting

=AND($A1 = "9993005", $B1 = "0157") =FALSE and apply this to all column B.

Then add additional rules for your other pairs

[gbfoligno]

Thank you so much everybody!

You guys are awesome! :D