Forum Discussion
Prompt User for Input for value in lookup table
=IF(A20=1,VLOOKUP(B20,'Course Offerings'!$A2:$B103,2,FALSE)) 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 Credit...
Hi,
If you need a Prompt, you probably have to write VBA.
but if you only need a drop down list, there is some Excel built-in function you can use. (I attached an example spreadsheet):
e.g. for this "Internship" course, you can input "1,2,3,4,5,6",
Then in your first sheet, you can use "TEXTSPLIT" to create a drop down list: