HiTekRedNek
Registered User.
- Local time
- Today, 10:31
- Joined
- Mar 11, 2010
- Messages
- 18
I am working with two spreadsheets that I have imported and would like to know if there is a way of finding matching data between two columns. The tricky part here (well for me anyways) is that the columns have similar data but one has a period separator with an extension value that I want to ignore. I want to exclude the period and everything afterward and simply have the query find the matching text.
Example
Column A from table 1 would display the text like this:
EXAMPLE
Column A from table 2 would display the text like this:
EXAMPLE.new
How can I put together a query that will match both entries across the 2 tables. If found I would like to insert a column in table 1 that would display a "yes" if found or "no" if not found?
Example
Column A from table 1 would display the text like this:
EXAMPLE
Column A from table 2 would display the text like this:
EXAMPLE.new
How can I put together a query that will match both entries across the 2 tables. If found I would like to insert a column in table 1 that would display a "yes" if found or "no" if not found?