Forum Discussion

melanie00518's avatar
melanie00518
Copper Contributor
Mar 26, 2019

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 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? 

Formulas and Functions

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 26, 2019

    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:

    https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

    https://www.youtube.com/watch?v=-hJxIMBbmZY

     

    Hope that helps

Resources