Concatenate Or Use Mid, Value, Match With And Functions
Rate this:
(3/5 from 1 vote)
The simplest method would be to create a separate column with a concatenation of the phone number columns and then use that column for the VLOOKUP function. e.g. =TEXT(A1)&"-"&TEXT(B1)&"-"&TEXT(C1)
Another more complex method is to use MID functions to extract each part of the phone number, convert the text to values, match them to the columns, and test if the matching index is the same for all three parts.
As an example, suppose the 3 parts of the phone numbers are in columns A,B and C from row 1 to 100 and the phone number is look for is in cell E1. the following formula will return TRUE is the phone number is found.
