How to compare data across calc worksheets

[LibreNacho]

I am looking to compare data from two separate worksheets.

Unfortunately the data is not formatted the same.
One is a do not call list and one is a list of leads.
one is formatted in a single cell as (###)###-#### and the the other is formatted across two cells. first cell area code ### and second cell #######

I am assuming I first need to make the formatting the same in both? If so and suggestions? Macro? Manual data entry (I hope not but do have admin staff…)

Thanks

[LibreNacho]

vlookup didn’t do exactly what I wanted but is workable.

[PaulHaz]

If you compare two cells, it is the values of those cells being compared and not the formatting.

Assuming the data is in columns, I guess you may need to create one or two new columns to manipulate the original values into a common form (edit out the brackets if they are part of the data, combine two cells into one). You can then reliably compare the data in the new columns.