Obtain customer phone number from ID in Excel

[dkjMusic]

Spreadsheet 1 (SS1) has a list of customers with unique ID for each. Spreadsheet 2 (SS2) has a list of those customers plus many more with the same customer IDs for those in SS1 plus each one's FAX number.

Problem: For each customer in SS1, how to find his/her FAX number from SS2 and insert it in a column in SS1?

[anghicole]

Like this?

[dkjMusic]

Thank you so much. Worked like a charm!