Basic formula help. How to type in a cell and then display adjacent cell.

Hi All,

I just need some help on something which I think should be fairly easy for most decent excel users.

I have run through a good number of the Lynda courses and am using Excel 365 however I am struggling to answer this question.

I have 2 sheets. One has a master list of customer, customer number, account balance... The next sheet I want to be the statement that I can save as a PDF.

I would like to be able to type in a customer number in a cell and then in the adjacent cell have the balance as is listed for that customer on the master sheet appear.

Can someone point me in the right directing as to what formula to use? Vlookup/INDEX??

Thank you

Chris

Vlookup should do this for you.

https://www.techonthenet.com/excel/formulas/vlookup.php

The paperclip does not work for uploading files. In the reply window, click on "Go Advanced" and scroll down to Manage attachments and then follow the upload wizard. Glad you solved it. Use this procedure in the future.