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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies