Hello,

Hopefully I can explain this throroughly.

I have 4 different regions as column headers in cells A1,B1,C1,D1. These are in Workbook 1

I have another workbook, workbook 2, that has Regions in Column A, Countries in Column B and Customer Codes in column C.

I want to have a formula that uses A1(South America) in workbook 1, looks it up in column A:A in workbook 2 and returns ALL the matching customer codes in C:C that are in South America in A2 to A(however many country codes there are)

I then want to drag this formula to the right so that it will return all the customer codes for each Column Header.

Thanks in Advance.

Mike