Tables comparison along with rows comparison and mismatch rectified with color notificatio

[harman83]

Table 1
Postal Code Place Name State Abbreviation County
73851 May Oklahoma OK Harper
76857 May Texas TX Brown
83253 May Idaho ID Lemhi


Table 2
Postal Code Place Name State Abbreviation County
73851 Me Oklahoma OK Harper
76857 May Texes TX Brown
8253 May Idaho ID Lemhi

1) Compare Table 1 with Table 2
2) wherever the value in table 2 is not matching with Table 1 it should be coloured out and rectified to correct one as given in table 1.
3) Ensure All the parameter in Row1 of table 2 should be compared with all parameter in Row 1 of Table 1 so that required value is updated.

[skywriter]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[harman83]

Please find attached my file. Table 1 is my main, table 2 is my table with incorrect entries, In table 3 I want correct entries to be filled. I want to tally all columns of my table to be verified to retrieve the correct information.

[jindon]

Just copy table1 to table3.....

[harman83]

Situation is

1) Table 1 is downloaded from internet

2) Table 2 is a manual entry wherein chances are infinity to do typing mistake.

3) My intent is to correct this typing error. And in order to do so my logic is to compare each row/cell of table 2 with table 1 and wherever there is typo against the value it should be rectified.

4) We could use Code as primary key, but there could be typing mistake in code entry also. So not sure how to handle this situation and where I need code to rectify the typing mistake at any row.

[skywriter]

Your explanation doesn't make sense. If table1 is a correct example of what you are looking for, then use table1.

[harman83]

I am collating a information where I am copying information from the internet which is a manual entry. In Table 2,I have just shown some of the columns from my main data.

I just want my table 2 where I am making typo errors should be rectified based on Table 1(as reference). Does this convey what my problem area is or you think I am not able to frame my query correctly?

[harman83]

Can anyone help with the solution please?

[skywriter]

In your example with the exception of a few typographical errors, table 2 seems to be identical to table 1. It has the same number of items and they are in the exact same spot, meaning rows and columns. Your typographical errors are in different columns, meaning in one the code is incorrect but all other items are correct. In others the place name is correct but other items are incorrect. How does one help you with this? If you said all the codes are correct but other items are misspelled I would say use a vlookup or index match formula. If you said all the other items were correct but the codes are wrong I would say we could probably use all the other items to look up the codes.

Does this convey what my problem area is or you think I am not able to frame my query correctly?

So yes I/we or maybe it's just me, are confused as to how to help you.

You don't seem to understand my/our position is that we don't understand why you can't just use table 1, again read my explanation above. You need to understand the difficulty in helping you.

The bottom line is if you have a table that is correct that you want us to somehow use code on to compare it to another table then you don't need the table with typos use the other table.