For the above lookup formula in Excel, I have a 2nd 2-column worksheet. It contains the Course Name in Column 1, and the Course Credits in Column 2. The trouble is that some courses have variable credits instead of a fixed number. How can I insert a place marker in the 2nd worksheet cells that amend the above formula to prompt the user for the variable credit amount?
For example, if an internship course has 1-6 credits for the course in the 2nd worksheet, how do I let the formula for the cell in the 1st worksheet ask for the specific credits for the course?