Type or select the range includes data C3:E7,.Start with =INDEX( which returns the range.=OFFSET(anchor point before headers, 1, MATCH(search value, headers of data, 0), ROWS(any column of data or even data itself), 1) Steps =INDEX(data without headers, 0, MATCH(search value, headers of data, 0)) How to return an entire column article will explain you how it can be done. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. ![]() To return an entire column you need array returning functions like INDEX or OFFSET.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |