Combining LOOKUPVALUES

[Anonymous]

I have two sheets Go LMS Signups and Flex LMS Signups and they both have a column called Requested Signups. I need to get the Requested Signup information from each of those sheets into a 3rd sheet as a column. The reference string for all three sheets is the email column. I was able to add two columns to the 3rd sheet, pulling that information individually from each sheet, but I want one column instead of two. How can I turn these two formulas that get me two columns, into one formula that combines this information? 

Flex Requested Signup Origin =

CALCULATE(

    FIRSTNONBLANK('Flex LMS Sign Up Requests (2)'[Requested Signup], 1),

    FILTER(all( 'Flex LMS Sign Up Requests (2)'), 'Flex LMS Sign Up Requests (2)'[User Email] = 'LMS User Analysis'[Email])

    )

 

Go Requested Signup Origin =

CALCULATE(

    FIRSTNONBLANK('Go LMS Sign Up Requests (2)'[Requested Signup], 1),

    FILTER(all( 'Go LMS Sign Up Requests (2)'), 'Go LMS Sign Up Requests (2)'[User Email] = 'LMS User Analysis'[Email])

    )

[Mahesh0016]

@Anonymous  I hope this helps you
Create a calculated Column following below :

C =

IF ( ISBLANK ( 'Table'[Flex Requested Signup Origin] ), 'Table'[Go Requested Signup Origin], 'Table'[Flex Requested Signup Origin] )