Classic use for vlookup. For example, if you have enter the acct# in A2 and
want to populate E2, then enter in E2 the formula
=vlookup(A2,Sheet2!A:E,5,false).
Just to populate columns B2,C2 and D2, put the same formula in those cells,
changing the 5 to 2,3 and 4, respectively.

"LearningExcel" wrote:

ESheet 2 has a list of all borrower account numbers in col A, col B,C,D,E
have the name, a % for calculations of this particular loan, & other data.

I need to input the account number on Sheet 1, Col A and have the
information from Sheet 2 columns (referring to this particular loan#)
automatically enter into the columns on Sheet 1.

Thank you.