Excel 2010 Lookup Function
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.
file.xlsx
file.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
These all work, thanks so much for the quick assistance. What I am looking to do is a bit more complex, so returning the phone number would be helpful along with the matching phone type (cell, home or work), . But this should get me started. Thanks again.
You're welcome!
Open in new window
file_b.xlsx