Excel 2007 : Checking values in columns C and D,are right combination?

**ALEZI** · 10-27-2010, 09:20 AM

Hello all,
I’m here again after some time, repeating nice words for you and your do not have sense more.
Now I have problem with administration of my production data, in some cases we have put wrong data in Table.
What I want to do, I will copy data from administration in columns C and D in form as I wrote in my dummy sheet, Excel should check according to combination latter/numbers in column D are right combination in column C. Columns C and D have to be emptied before I would paste data into them and have to have possibilities expanded if I need this .If some mistake founded show me in column E message.
I hope that you understand me.

**Huron** · 10-27-2010, 11:35 AM

I would add a helper column H to join the possible combinations using the formula
=F2&";"&G2

You can then use a vlookup formula in column E to check the values in columns C and D against column H

=IF(ISNA(VLOOKUP(C2&";"&D2,$H$2:$H$5,1,FALSE)),"Wrong!!","Correct")