Question: 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
(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
Get step-by-step solutions from verified subject matter experts
