Forum Discussion
melanie00518
Mar 26, 2019Copper Contributor
VLOOKUP Help
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 sh...
Haytham Amairah
Mar 26, 2019Silver Contributor
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 Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function
Hope that helps