I would like to know how to use VLOOKUP or any other function that would search for a " text or numeric value" in Multiple columns and returns a value if matched. For instance, I have Col A = [Phone 1], Col B = [Phone 2], Col C = [Phone 3] and finally Col D = [contact name]. So my objective is to have Col F return the respective [contact name] based on the input in Col E that would search for the matching string in the entire Columns A & B & C . I have a limited knowledge on VLOOKUP function but since there are multiple columns to search, I don't know if VLOOKUP works here and if not what alternative functions can be used to achieve this?
File attached
Bookmarks