Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an excel code that shows if the student pass or fail, note that if the student got 60 or more in at least 2

Write an excel code that shows if the student pass or fail, note that if the student got 60 or more in at least 2 exams then the student passed and write pass, if not write fail image text in transcribed
(1) Write VBA function that mimic the work of VLOOKUP function. You must: Use the function name MYVLOOKUP. Use while loop inside the function. Use all the following input parameters: VR The lookup Value Row index. VC The lockup Value Column index. SR The index of the lockup table Starting Row. SC The index of the lockup table Starting Column ER The index of the lockup table Ending Row. EC The index of the lockup table Ending Column. OC The Output Column. Assume that: The lookup value is a numeric value. The lookup table is sorted in an ascending order. The function should behave like range lookup function. Hint: instead of using the standard VLOOKUP function you need to call the function MYVLOOKUP as shown below VLOOKUP(E4, Al: C10 ,3) MYVLOOKUP(4,5, 1,1, 10,3,3) Both functions should give the same result. (1) Write VBA function that mimic the work of VLOOKUP function. You must: Use the function name MYVLOOKUP. Use while loop inside the function. Use all the following input parameters: VR The lookup Value Row index. VC The lockup Value Column index. SR The index of the lockup table Starting Row. SC The index of the lockup table Starting Column ER The index of the lockup table Ending Row. EC The index of the lockup table Ending Column. OC The Output Column. Assume that: The lookup value is a numeric value. The lookup table is sorted in an ascending order. The function should behave like range lookup function. Hint: instead of using the standard VLOOKUP function you need to call the function MYVLOOKUP as shown below VLOOKUP(E4, Al: C10 ,3) MYVLOOKUP(4,5, 1,1, 10,3,3) Both functions should give the same result

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions