Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT683-685.xlsx

See how to do 1 Condition Lookup Adding for both the VLOOKUP and HLOOKUP functions. See how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm