Excel Forum

Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP

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

Got a Question? Ask it Here in the Forum.