floridagunner
MIS
I need to do a complicated lookup on very big Excel file and was hoping someone could provide either with the VBA Code or even a formula.
My problem is this:
Sheet 1 has this information:
Account # Contact Name
1234 Mike
1234 Dave
1234 John
5678 Amy
5678 Joe
3215 Mike
Sheet 2 has this information:
Account # Contact Name
1234
1234
1234
2365
5678
5678
3215
When I do a VLookup to populate the contact names I only get back one name per account number when infact a lot of account numbers have more than one contact name assigned to them.
Can any body help me with a formula or a macro. These are pretty huge files and thats the reason I am thinking of doing inserting a Macro.
Any help/suggestions will be greatly appreciated.
Thanks
My problem is this:
Sheet 1 has this information:
Account # Contact Name
1234 Mike
1234 Dave
1234 John
5678 Amy
5678 Joe
3215 Mike
Sheet 2 has this information:
Account # Contact Name
1234
1234
1234
2365
5678
5678
3215
When I do a VLookup to populate the contact names I only get back one name per account number when infact a lot of account numbers have more than one contact name assigned to them.
Can any body help me with a formula or a macro. These are pretty huge files and thats the reason I am thinking of doing inserting a Macro.
Any help/suggestions will be greatly appreciated.
Thanks