Pls Help

A

abhijitan

I Have A Workbook In Which Sheet1 Contains A List Of Roll Numbers And
Names Of Students . In Sheet2 , I Want , When I Will Enter The Roll
Number Then The Name Of The Students Should Appear Automatically. Pls
Help .
Thanks
 
P

Peter Ellis

Try using the vlookup function. On sheet 2, enter the Rollnumber in a
column, then to its left, use the Vlookup function to lookup the name given
the roll number. E.g. if the roll number is in cell D9, then in cell E9 enter

=VLOOKUP(D9,Sheet1!$C$9:$D$12,2,FALSE)

The table in sheet 1 should have the roll number in the first column of the
table, with the associated name in the column right next to it. The dollar
signs indicate an absolute reference and will ensure you can copy the formula
with the fill handle. The false tells the function to look for an absolute
match in the roll number and not a range lookup
 
B

Bob Phillips

Assuming the data on sheet1 is in A1:B20, and you enter the roll number in
A1 of sheet 2, in B1 of sheet2 enter

=VLOOKUP(A1,Sheet1!A1:B20,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

Domenic

Assumptions:

For Sheet1...

A2:A100 contains the roll number

B2:B100 contains the student name

For Sheet2...

A2 contains the 'roll number' of interest

Formula:

For Sheet2...

=VLOOKUP(A2,'Sheet1'!$A$2:$B$100,2,0)

Hope this helps!
 
Top