How to make this expression correct?

[BHUVANESH]

MY EXPRESSION IS

IF((IN([_THISROW].[order],Tickets[Order])),

LOOKUP([_THISROW].[Order],"Tickets","Order","Customer"),

ANY(SELECT(Customers[Name],AND([_THISROW].[Customer Id Orders]=[B2A ID],NOT(CONTAINS([Name],@))))))

ERROR SHOWS

IF function is used incorrectly:the second input (if-result) and third input(else-result) should have the same type..HOW TO RECTIFY THE ERROR

[Suvrutt_Gurjar · Accepted solution]

Since the error is talking about column type of the results, you may want to verify if the column [Customer] in the "Tickets" table and the column [Name] in the table "Customers" are of same column type.