I uploaded a sample Excel file with 2 tabs. The first first tab, named Lookup contains in Cell A2 a Phone Number. I would like to type in a lookup formula in Cell B2 to scan the first 3 columns in the Phone Tab worksheet at the same time and bring back a match number. The full file has many more rows of phone number, I am not sure the easiest method to do this, also is there a way to indicate which Column where a match is found as well (Cell, Home or Work). Thanks for any help.