PDA

View Full Version : Searching for items in another excel sheet



Klartigue
09-01-2011, 06:10 AM
A1 BMO Capital Markets
Cover Wells Fargo
A2 UBS Financial Svc
Cover Morgan Stanley
A3 Southwest Securities
Cover Piper Jaffray
etc..

In column M of my spreadsheet, the names of brokerage firms are listed as above. I have another spreadsheet called the settlement sheet located at G:\Katherine Lartigue\Instructions that contains all of the broker contact and phone numbers. How would I write a macro that looks at the brokers only for A1, A2, A3, etcc.., finds that broker contact name and number (listed in column F of the settlement sheet) on the settlement sheet, and copy and paste that phone number in column U of my main sheet?

Thanks for the help.

Chabu
09-01-2011, 02:10 PM
Sounds like a Vlookup, please provide the seet as example.