imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
Hello,
I've got a problem. I've illustrated it with an example below:
Sheet 1
Employee Name Designation
John Manager
Smith Executive
Allan Sales
Smith Sr. Manager
Steven Sales
Ann Receptionist
Sheet 2
Ann Receptionist
Smith Executive
Harris #N/A
Chris #N/A
John Manager
Adams #N/A
Smith Executive
Allan Sales
Let's tale for example there are 2 people in the company by the name of Smith. (executive and Sr. Manager). While doing a vlookup in sheet 2, in both places you will only get the result for designation as 'executive' for Smith. This is because vlookup only picks up the 1st value and matches it against corresponding database.
Is there any way to eliminate this problem or better still, is there any other formula that can be used to match "smith" against "executive" and "smith" against "sr. manager" while comparing data bases? Pls revert back ASAP.
Thanks
Straus
I've got a problem. I've illustrated it with an example below:
Sheet 1
Employee Name Designation
John Manager
Smith Executive
Allan Sales
Smith Sr. Manager
Steven Sales
Ann Receptionist
Sheet 2
Ann Receptionist
Smith Executive
Harris #N/A
Chris #N/A
John Manager
Adams #N/A
Smith Executive
Allan Sales
Let's tale for example there are 2 people in the company by the name of Smith. (executive and Sr. Manager). While doing a vlookup in sheet 2, in both places you will only get the result for designation as 'executive' for Smith. This is because vlookup only picks up the 1st value and matches it against corresponding database.
Is there any way to eliminate this problem or better still, is there any other formula that can be used to match "smith" against "executive" and "smith" against "sr. manager" while comparing data bases? Pls revert back ASAP.
Thanks
Straus