How to make Daily Progress Report Part 3/How to use VLOOKUP,Data validation,How to use list box
Hi
i am Munir Khan Welcome to our youtube channel munir khan
how to create monthly report in excel,how to create a summary report in excel,how to create a daily report in excel,How to quickly create daily/weekly/monthly reports with same format in Excel,HowTo.Excel: How to make Daily Activity Report sales report,How do I make a daily activity report,How do you write a summary for a report,How to make Daily Progress Report for Construction Site/ Progress Gantt Chart in Excel
Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly.
How to use VLOOKUP in Excel
Click the cell where you want the VLOOKUP formula to be calculated.
Click "Formula" at the top of the screen.
Click "Lookup & Reference" on the Ribbon.
Click "VLOOKUP" at the bottom of the drop-down menu.
Specify the cell in which you will enter the value whose data you're looking for.
Use VLOOKUP
In the Formula Bar, type =VLOOKUP().
In the parentheses, enter your lookup value, followed by a comma. This can be an actual value, or a blank cell that will hold a value: (H2,
Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
Enter column index number. This is the column where you think the answers are, and it must be to the right of your lookup values: (H2,B3:F25,3,
Enter the range lookup value, either TRUE or FALSE. TRUE finds partial matches, FALSE finds exact matches. Your finished formula looks something like this: =VLOOKUP(H2,B3:F25,3,FALSE)
What is data validation in Excel?
Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.
Image result for how to use data validation in excel
View all
Add data validation to a cell or a range
Select one or more cells to validate.
On the Data tab, in the Data Tools group, click Data Validation.
On the Settings tab, in the Allow box, select List.
In the Source box, type your list values, separated by commas. ...
Make sure that the In-cell dropdown check box is selected.
level sheet for surveying in excel 02 munir khan
• level sheet for surveying in excel 02...
level sheet for surveying in excel 01 munir khan
• level sheet for surveying in excel 01...
level sheet for surveying in excel munir khan
• level sheet for surveying in excel mu...
Youtube - / @kmunir22
Facebook- / kmunir22
civil 3d alignment and profile
Email - [email protected]