Name Fill In

  • Thread starter Thread starter Sean NWIC
  • Start date Start date
S

Sean NWIC

I would like to have it so that I can type in a student's ID Number in C11
and it is replaced with matching info to Sheet2 in the same row. I want the
name to be as: "SHEET2FIRSTNAME"," ","SHEET2LASTNAME"
and in C12, for in that same row, the address shows up from Sheet2
City in C13, State in E13, and ZIP in G13

There are about 500 student names and I'm not sure where to start.
Thank you,
Sean
 
Assumptions: On sheet 2, column A contains ID#, B contains first name, C
contains last name, D contains address, E = city, F = state, G = zip

Basic formula structure is:
=VLOOKUP($C11,Sheet2!A:G,2,FALSE)

The keypart of this formula is the 3rd arguement. This controls which column
to return info from. Thus 2 returns column B, 3 returns column C, etc.

Your question was also confusing in that you keep saying "in the same row"
but make references to row 11, 12, and 13.
 
OK...
Here's what I want to do:

In SHEET2;
A="ID Number, B="Last Name", C="First Name", D="Address",E="City",
F="State", G="ZIP"

When I enter the "ID number" on SHEET1 in C11
In SHEET1 I want this to automatically be filled in:
C11=COLUMN "C", space, COLUMN "B"
C12=COLUMN "D"
C13=COLUMN "E"
E13=COLUMN "F"
G13=COLUMN "G"






__________________________________________________
 
Back
Top