I am having issues comparing the results of two vlookups. I'm looking up information based on a position from two different systems where we use the same name convention.
Sheet1 has a phone number in 2 blocks, area code and then phone number.
Sheet2 is from our cell phone provider
I am trying to compare the results of 2 separate vlookups.
Vlookup1 Cell B2
"=CONCATENATE(VLOOKUP(A2,Sheet1!A2:C3,2,FALSE),VLOOKUP(A2,Sheet1!A2:C3,3,FALSE))"
Vlookup2 Cell C2
"=VLOOKUP(A2,Sheet2!A2:B3,2,FALSE)"
The lookups report the phone numbers back correctly but I can't see to compare the results. To test this I'm using a simple IF, but ultimately will be conditionally formatting and nesting into other formulas.
=IF(B2=C2,TRUE,FALSE)
Bookmarks