Microsoft Excel ACM Quick Tip - How to use the VLOOKUP function

Welcome to an ACM quick tip video. This lesson will be on using the VLOOKUP function. -This function comes in handy when we have a very large set of data and we’re trying to find something within the data or specific row. Note that VLOOKUP will not return multiple values if there are more than one “LOOKUP VALUE” or ‘search item’ within the column. So in column G on our spreadsheet, there are more than one Franklinton’s and Dublin’s. This function will not return all those values. PIVOT TABLE VIDEO - https://www.youtube.com/watch?v=41S4B2U02Ws&t=15s -When your data is organized, select a cell where you want the value or data to appear once we establish all the criteria of the VLOOKUP function. -Then type in = SIGN, VLOOKUP, PARENTHESIS. -For the first criteria, select a cell where you want to type in your “search”. This is the LOOKUP VALUE, or what you will be searching for in order to find the value within that same row. Once you have that, hit COMMMA. -Next part is to highlight all the data you want to include in your search. Type COMMA once complete. -Then we type in the column number which includes the value we want returned. This number starts from the first column of your selected data. In this case we want the second one over, so we type in number 2. COMMA. -Last criteria: select TRUE if you want an approximate match. Select FALSE if you want an exact match. END PARENTHESIS. -Now when we search for an area in our lookup value cell, it sorts through the data, finds a match, then returns the value in the same row for the column we specified. At Administrative Controls Management (ACM) we aim to provide you and your team with the necessary tools and knowledge to carry out your project successfully. We are here to help with any of your project's needs such as planning and scheduling, estimating and cost engineering, project management, project representation, training, construction delay claims, and consulting. Our Youtube channel will provide you with quick tips and tutorials on how to use popular software such as Microsoft Excel, Microsoft Project, Primavera P6, and SAP. ACM is a certified woman-owned business providing value added project management and controls services since 1985. ACM’s team of highly qualified professionals support a wide range of industries such as heavy civil, oil & gas, manufacturing, university construction, healthcare, and nuclear power. ACM is the first Approved Education Provider as certified by AACE International and a Project Management Institute Global Registered Education Provider. For more information on how ACM can help you or your business, please visit acmpm.com. Don’t forget to hit the subscribe button if you want to stay up to date with everything that ACM has to offer. Thanks for watching! #VLOOKUP #Excel #lesson