Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Re-create the model below that searches the students table and returns the data on the student, given a student id. Download database file Students.csv
Re-create the model below that searches the students table and returns the data on the student, given a student id. Download database file Students.csv and import into your workbook (Figure 4). The model works by having the user enter the ID and Excel returns the details stored in the database table. Figure 5: for example, ID k0962 is entered by the user and Excel returns the related Info data. Use the ID value input as the lookup value for VLOOKUP. The solution should be a single 'master' formula that would work for any attribute i.e., the formula that returns the correct Name in the searcher Info is appropriate for being Auto-Filled down the column to return the rest of the attributes available in the Database. Place the searcher at the top of the worksheet if the database and the Searcher components are in the same worksheet. Key functions to use: VLOOKUP, MATCH; possibly INDEX B D E F 1 ID Name Gender Date of Birth Weighted Average Final Grade Remark 2 k0688 Jake 3 k0222 Gab M 10/12/2008 67.47 C Good M 13/12/2008 DEF 4 k0270 5 k0213 Sarah F Pearl F 14/11/2008 74.35 B Very good 26/06/2008 DEF 6 k0120 7 k0494 Parkes M Felicity F 29/06/2008 60.24 04/08/2008 74.65 11 k0678 8 k0366 Harvey M 9 k0283 Jamie M 10 k0214 David M M 29/10/2008 57.76 20/09/2008 70.88 04/04/2008 80.00 Fred 09/09/2008 64.35 12 40980 Wishmo M 17/08/2008 56 53 CBDBACD Good Very good Pass Very good Excellent Good Pass Figure 3 students table Enter ID to search k0962 Name Gender Info Oscar M 25/09/2008 Date of Birth Weighted Average 65.35 Final Grade Remark C Good
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started