INDEX COLLECT

SamprasFederer

Why am I not getting any answers from this formula? I have been using the same formula quite a lot and it works fine. What exactly is missing here?

The red rectangle would be my return if my formula is correct...

Thank you for your help in advance

Jeff Reisman

@SamprasFederer

The formula syntax looks ok. First thing I would check is that your range references are correct. In your formula, right click on each reference and select Edit the Reference to see where they are pointing.

(Just a note on range names - as a best practice, I try to rename ranges to show which column I'm referencing in the remote sheet. It just makes things easier to troubleshoot, especially after time has gone by. So in your case, I would rename {CKT Master IP Table Range 3} to {CKT Master IP Table Type}. )

SamprasFederer

Hi Jeff,

Thank you so much for your advice and will follow you advice next time, having said that I have removed the IFERROR to see what my problem is...is still giving me "#INVALID REF" as my error, I have checked my reference over and over again and it looks correct. My reference sheet is 250 rows in size (would that not work)? I have had much larger size sheets and it works fine.

Thanks you for your help again.