Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
You posted this question by jumping in a thread strated by Shane. I replied as follows:
Change the formula to:
=OFFSET(Cover!$A$23,0,0,MATCH(REPT("z",255),Cover!$A:$A)-22,1)
22 takes into account that your actual data start at row 23.
I added 1 as the 4th arg of OFFSET to tell it that the range consists of a single column. If your data range counts more columns, adjust this number accordingly: For example, A to C houses the relevant range, then that number should be 3.
The MATCH(REPT("z",255),Cover!$A:$A) bit should used if column A-values consists of text values as opposed to date-values or just numbers.
Aladin
Change the formula to:
=OFFSET(Cover!$A$23,0,0,MATCH(REPT("z",255),Cover!$A:$A)-22,1)
22 takes into account that your actual data start at row 23.
I added 1 as the 4th arg of OFFSET to tell it that the range consists of a single column. If your data range counts more columns, adjust this number accordingly: For example, A to C houses the relevant range, then that number should be 3.
The MATCH(REPT("z",255),Cover!$A:$A) bit should used if column A-values consists of text values as opposed to date-values or just numbers.
Aladin