Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 4th 17, 03:04 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2017
Posts: 1
Default vlookup formula for my enrollment database

Hi there,

I am working with my enrollment database and i have problem with my look up value. I am using the last name of my student as my look up value, however, four of my students have the same last name but different first names. When a type the last name only one student name will always appear. How can i solve this problem. To illustrate:

Subject: PolSci102
Last Name:_____________ - this is the A2 in my student profile sheet
First Name: =vlookup(A2,'PolSci102'!$A$3:$V$749,2,FALSE) - where my problem is
Middle Initial: =vlookup(A2,'PolSci102'!$A$3:$V$749,3,FALSE)
Class Block No.:=vlookup(A2,'PolSci102'!$A$3:$V$749,4,FALSE)
Prelim Grade:
Midterm Grade:
Pre-Final Grade:
Final Grade:

similar sample (name not true, sorry if it accidentally identifies someone else)

Last Name Column First Name Column Middle Initial
dela cruz Juan I.
dela Cruz Juana Q.
dela Cruz Jessie B.
dela Cruz Jason M.

Thank you guyz,




  #2   Report Post  
Old November 6th 17, 12:14 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,083
Default vlookup formula for my enrollment database

FWIW
I use a different approach in my Student Grades Manager app where student names
are not in separate fields but are listed as...

"Lastname, Firstname Middle Initial"

...in the 1st column. The StudentID follows in the 2nd column of the class
ledger. The various subject/assignment modules follow in the subsequent
columns. Weighted scores are calculated in the last module followed by Final
scores (%avg, Grade, PtAvg) are calculated in the last 3 columns via a lookup
in a GradesTable.

This works well and simplies when uploading grades to a central location.
Perhaps you could simplify your project to obviate this issue and any others
that may arise?<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup to txt file or database Lisa Excel Discussion (Misc queries) 5 May 7th 09 12:55 AM
Calculate eligibility/enrollment date [email protected][_2_] Excel Worksheet Functions 8 December 23rd 08 08:26 PM
Statistics Plus Minus Enrollment [email protected] Excel Worksheet Functions 5 December 17th 06 02:25 AM
vlookup and Access Database Table finster26 Excel Discussion (Misc queries) 1 January 6th 06 11:17 PM
VLOOKUP in another workbook/Access database Chris Carr Excel Programming 4 August 3rd 05 06:14 PM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017