Excel for Engineers - Introduction to the VLOOKUP Function
In this video, I will introduce the VLOOKUP function in Excel. Often as engineers, we need to look up fluid properties in tables. Using the VLOOKUP function in Excel, we can automate this task.
If you would like to follow along, you can find the Excel file used in this video on my personal website at http://bit.ly/dcytvlookup
The property data used in this video was obtained from Cengel, Y. A., and Ghajar, A. J., 2015, Heat and Mass Transfer: Fundamentals & Applications, McGraw-Hill Education, New York, pp. 926.