Forum Discussion
New Column formula replace null with other
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"))
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] )
2 Replies
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] )