New Column formula replace null with other

[Anonymous]

I'm pulling a status from here Account (sheet) Flex or Go Customer (column).

I'm using an account relationship that both sheets have (Account #).

It's returning the text values correctly, however, it's also turning blanks. 

I want to replace the blanks that are being returned with a value from another column in the Account sheet (status).

This is my current formula. How do I adjust this to return the info from the other column if the result is blank?

Flex or Go = (LOOKUPVALUE(Account[_Flex or Go Customer], Account[_Account #], 'NPS 2017 Q4'[Account #], "no data"))

[Anonymous]

Amazing! Just what I needed and I learned something new. Thank you!!

[edhans · Accepted solution]

Wrap the whole thing in a COALESCE() function.

Flex or Go =
COALESCE (
    LOOKUPVALUE (
        Account[_Flex or Go Customer],
        Account[_Account #], 'NPS 2017 Q4'[Account #],
        "no data"
    ),
    Account[AlternateValue]
)