Skip to main content
Super User

Return to Answer

added 81 characters in body
Source Link
Dave
Dave
  • 25.4k
  • 11
  • 59
  • 70

Vlookup()Vlookup() should work. With the Student names in column A, row 1 has the labels, start this formula in cell B2 and copy down

=vlookup(A2,SheetB!$A$1:$B$100,2,false)

=vlookup(A2,SheetB!$A$1:$B$100,2,false)

This is on the assumption that the grades are listed on a sheet called SheetB. Adjust sheet names and ranges as required.

Vlookup() should work. With the Student names in column A, row 1 has the labels, start this formula in cell B2 and copy down

=vlookup(A2,SheetB!$A$1:$B$100,2,false)

This is on the assumption that the grades are listed on a sheet called SheetB. Adjust sheet names and ranges as required.

Vlookup() should work. With the Student names in column A, row 1 has the labels, start this formula in cell B2 and copy down

=vlookup(A2,SheetB!$A$1:$B$100,2,false)

This is on the assumption that the grades are listed on a sheet called SheetB. Adjust sheet names and ranges as required.

Source Link
teylyn
teylyn
  • 23k
  • 2
  • 42
  • 54

Vlookup() should work. With the Student names in column A, row 1 has the labels, start this formula in cell B2 and copy down

=vlookup(A2,SheetB!$A$1:$B$100,2,false)

This is on the assumption that the grades are listed on a sheet called SheetB. Adjust sheet names and ranges as required.