Excel Forum

Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function

See how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

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

Got a Question? Ask it Here in the Forum.