Fill missing fields formula

[sy2071]

Hello everyone,
I'm new here and I've searched for this problem but I couldn't find an answer. Perhaps I was not entering the correct search so I thought I would ask for help. I have a large master sheet with customer ID, name, address, and telephone number. I have a second worksheet with just the customer ID and name for customers with a balance. I need to add the address and telephone numbers to this second worksheet.

Can I use a formula to fill in fields "Address" and "Telephone#" by searching the master list for the customer ID?

Thank you in advance for your responses!
-Shawn

[Glenn Kennedy]

Hi there... and welcome to the Excel Forum.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic