Formula that looks at value in a cell and depending on what the value is

Solution 1:

You'll need nested if() statements, like:

if 25 then Account1 otherwise (else), if 58 then Account2 otherwise...

=IF(A1=25,"account1",IF(A1=58,"account2",""))

The format for the IF() function is IF(logical_test, value_if_true, [value_if_false]) and you're just placing another IF() function in the [value_if_false] repeatedly.