Hello all! I am trying to have a cell auto populate information based upon values in another sheet. For example, in Sheet 1, I have the columns "Customer" and "Notes". In Sheet 2, I have the same columns. I would like to enter a formula in Sheet 1 in the Notes column which would auto populate the notes from Sheet 2 when the Customer is added in Sheet 1. Is this possible? I tried the vlookup function, but that failed. Thanks for any help you can provide!
Help Article Resources
Check out the Formula Handbook template!