Occasional Visitor

Hello all -

I have two Excel workbooks. One of the workbooks has costs of customer purchases. The other does not. Both workbooks have the Customer ID. The second workbook has all customers in the sheet and the first workbook only shows customers with purchases within the last month. I need to get the customer purchases amounts from the first workbook into my second workbook. How can I do this efficiently? 

1 Reply

Hi @melanie00518,


If the Customer ID is located on the leftmost side of the table in which the customer purchases exist.

Then you can use the VLOOKUP function.


To learn more about VLOOKUP and how to use it, please check out these two link:

VLOOKUP function

VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function


Hope that helps