The web project in solution file is unavailable. Project reload show this message;
Here is the solution;
IIS Manager is required to run this web app and IIS Express doesn’t have IIS Manager or any UI. Following solution will work on IIS Express.
When you open Visual Studio and get the error message, right-click the project Solution Explorer and choose “Edit {ProjectName}.csproj”
In the project file, change the following line: <UseIIS>True</UseIIS> to <UseIIS>False</UseIIS> Save the file.
In my case it was this;
<UseIISExpress>true</UseIISExpress>
Now reload your project. Done.
You’ll then be able to open your project. If at this point, you want to use IIS, simply go to your project properties, click the “Web” tab, and select the option to use IIS. There’s the button there to “Create Virtual Directory”. It may tell you that you need to run Visual Studio as an administrator to create that directory, so do that if needed.
There is a list option in Data validation. If this is combined with a VLOOKUP formula you would be able to convert the selected value into a number.
The steps in Excel 2010/2019 are:
Create your list with matching values.
On the Data tab choose Data Validation
The Data validation form will be displayed
Set the Allow dropdown to List
Set the Source range to the first part of your list
Click on OK (User messages can be added if required)
In a cell enter a formula like this
=VLOOKUP(A5,$E$5:$F$8,2,FALSE)
which will return the matching value from the second part of your list.
Form control drop down
Alternatively, Form controls can be placed on a worksheet. They can be linked to a range and return the position number of the selected value to a specific cell.
If you don’t see Developer tab in Excel ribbon, follow this link;
The IEnumerable and IQueryable are used to hold a collection of data and also used to perform data manipulation operations such as filtering, Ordering, Grouping, etc.