AnsweredAssumed Answered

Lookup Record Value

Question asked by AlexXander on Feb 12, 2012
Latest reply on Feb 13, 2012 by AlexXander


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)

  2                43

  3                71


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)