Lookup Record Value
Is there a way to make a formula return the value of a field where a criteria matches.
So a formula to return the value in Field B where Field A=(????) , granted that Field A is all unique values.
Field A Field B (Field C)
1 36 (43)
So in Field C there would be a formula that states (Where Field A=2 Then return the value in Field B which equals 43)