### Title

Lookup Record Value

### Post

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)

In what field would you specify the matching value for Field A to use for looking up a a value in Field B?

This looks like you need two tables. One table storing the values for Field A and B, a second table with a value for Field A on which to specify the match. Then a calculaiton field can refer to the related value in B or you can use a looked up value fields setting to copy the value or you can just put Field B on your layout based on the other table. In all cases, your relationship would look like this:

TableShownAbove::FieldA = SecondTable::MatchValueForFieldA