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.