in regards to this question
obviously i have more data then i included in the example, as sheet1 is 90k plus enterys.
and i have a couple other large sheets referenced that are not directly part of the problem
so the information i am trying to retrieve exists on column 3 (C) of sheet 4, i have modified the formulae as follows
and entered with ctrl + Shift + enter and i am getting no data.
should it matter that sheets 1-4 are from sql data connections? or is there something obvious im doing wrong