I have an excel worksheet 1 with a list of contact information. Column A = Name; Column B = Address (Building No., Street, Unit No.); Column C = City; Column D = State; etc... Now, I would like to create a form in excel (worksheet 2) whereby when I enter a "NAME" in one cell (A1), other specified cells will automatically populate with info from worksheet 1. For example, A3 will populate with "ADDRESS" corresponding to the NAME provided in A1; A4 will populate with "CITY" corresponding to the NAME in A1; etc. I just wonder if that's possible with excel.

Any feedback will be greatly appreciated!