CCkfm2000
04-03-2007, 08:07 AM
hi all..
need help with the following
name defined "Grabdata"
=OFFSET(Data1!$B$1,MATCH(TEXT(Main!$B$15,"#"),Data1!$A$2:$B$65536,0),0,COUNTIF(Data1!$A:$A,Main!$B$15),4)
formula within worksheet
=IF(ISERROR(INDEX(grabdata,ROW()-16,2)),"",INDEX(grabdata,ROW()-16,2))
the spreadsheet was to big to post so i've had to cut most of the data out.
i've attached a copy of my spreadsheet
regards to all....
cckfm2000
need help with the following
name defined "Grabdata"
=OFFSET(Data1!$B$1,MATCH(TEXT(Main!$B$15,"#"),Data1!$A$2:$B$65536,0),0,COUNTIF(Data1!$A:$A,Main!$B$15),4)
formula within worksheet
=IF(ISERROR(INDEX(grabdata,ROW()-16,2)),"",INDEX(grabdata,ROW()-16,2))
the spreadsheet was to big to post so i've had to cut most of the data out.
i've attached a copy of my spreadsheet
regards to all....
cckfm2000