I have two excel files, and both which contain some customer IDs and other information. Let's say the Excel File 1 (EF1) contains all of my customer IDs and their respective purchasing amounts and other stuff. Then Excel File 2 (EF2) contains specific customer IDs that I want to work on. Right now, I would like to look up the specific purchase amounts from EF1 of customers identified in EF2 and then record those amounts in EF2.

The closest thing that I could think of using is pivot table. But since there is nothing for me to sort and I would need to ultimately need to record those numbers on EF2, I don't think pivot table would work. I am wondering if I could write a command that is something like: = the value of the cell, one column next to the column that contains the ID only if (or whenever)the customer ID matches (assuming the cell next to the customer ID is the purchasing amount in EF1)

Thanks!