matching records

  1. C

    Mismatched data between two tables and two fields

    I'm trying to get my head around how to find a situation where I might have a field where two tables match, but, where another field might not. I'll try and explain this the best I can. Table 1: <tbody> Lease ID Ticket Number 22045 100542 22046 100543 22047 100544 22048 100545...
  2. A

    Finding matching records from two tables

    Hi all, I have two tables, both contain a column of ID numbers and a column of addresses. I would like a method to match the IDs from table1 to those of table2 - if no matches are found, search for matching addresses, if a match is found then output the ID in table1, the address, and the...
  3. A

    lookup containing specific words

    Hi there, i have a list of address in Sheet 1 Column A, also i have a list of only states in Sheet 2 Column A i want to check if the state names in Sheet 2 Column A are present in Sheet 1 Column A below is the example... Sheet 1 Column A 1 Maharashtra, india 400086 Tel...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top