Enter A/C# on Sht1 Col1, Sht1 Col2,3,etc auto filled in from Sht2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function (if more that 7 nesting) 2
Auto populate cell with info on other cell (Sheet) 4
help with syntax for copy and pasting rows across sheets 4
Copy Column D from all worksheets in WB1 and paste in sheet1 WB2 10
Lookup Formula 4
copying data to summary sheet 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Criteria to return maximum value where x = x 3

Back
Top