Automatically display the information from sheet 1 to sheet 2

**wikiwinn** · 01-24-2009, 01:21 PM

hi, could anyone help me ?

In my excel sheet, sheet 1 contain Student's Information. Like this,

Column A Column B Column C
StudentRN StudentName StudentMEDM
1 AA MEDM-1111
2 BB MEDM-2222
3 CC MEDM-1232
4 DD MEDM-1221

In sheet 2,
I want to type StudentRN in Column A randomly.
I want to display automatically StudentName and StudentMEDM in Column B and Column C.

Like this.
If I type "4" in Column A of Sheet 2, BB (in column B) and MEDM-1221 (in column C) will be displayed automatically.
If I type "2" in Column A of Sheet 2, DD (in column B) and MEDM-2222 (in column C) will be displayed automatically.

Could any one help me to solve this problem?
Thanks in advanced.
Wiki Winn

**JBeaucaire** · 01-24-2009, 01:49 PM

This is a standard VLOOKUP function. On sheet2, in B2, try something like:

=VLOOKUP(A1,Sheet1!$A$2:$C$100,2,False)

And in C2:
=VLOOKUP(A1,Sheet1!$A$2:$C$100,3,False)

....and copy those two numbers down.

If you want to copy those formulas down further than you have answers in column A yet so it's automated, then preface those formulas with some sort of "check":

B2 =IF(A1<>0,VLOOKUP(A1,Sheet1!$A$2:$C$100,2,False),"")
C2 =IF(A1<>0,VLOOKUP(A1,Sheet1!$A$2:$C$100,3,False),"")