Need Value from same field of a different record

I'm looking to be able to reference the value of a field from a different record using certain parameters in the same table. Context:  I have a field collection form that has hundreds of manual en...