INDEX SMALL ROW Formula #REF! error.

**elcasey125** · 12-10-2008, 04:31 AM

I have the formula (found in cell "C2") on the Report sheet. I need to perform a function, but I cannot get it to work on the sheet I need to pull information from. The sheet RecapWk12 has a small section pasted (with some cells edited for obvious reasons) from the actual workbook. I can get the formula in Report cell (A10) to work on pulling information from sheet2. You can see I am getting (#REF!) in cell C2. What do I need to do to correct this problem? Is the name of the sheet the problem?

**Gearcutter** · 12-10-2008, 05:03 AM

Hi
Change
=INDEX(RecapWk12!C2:G19,SMALL(IF(RecapWk12!C2:G19="2",ROW(RecapWk12!C2:G19)-ROW(RecapWk12!C2)+1,ROW(RecapWk12!G19)+1),4),4) to

=INDEX(RecapWk12!C2:G19,SMALL(IF(RecapWk12!C2:G19=2,ROW(RecapWk12!C2:G19)-ROW(RecapWk12!C2)+1,ROW(RecapWk12!G19)+1),4),4)
Remove the " " from around the 2
Regards Howard