Display Title Based on Critera

[jpettit1]

I have 2 lists that I'm comparing. I'm trying to visualize "Apps Removed Since October." Both tables are identical so I changed the field names in but associated them by "App Name." The following syntax get me the correct result but it display's the ID of the record and I want the records "App Name" of. So, I know I can compare the 2 lists now by looking at if the AppID fields are not equal then display the AppID from the list I want the "App Name" from. How do I display the "App Name"?

=if(OctAppID<>[App ID],OctAppID,'')

List 1 "October"

App Name

OctAppID

Last Reported

List 2: "December"

App Name

AppID

Last Reported

Install Date

[lorenzoconforti]

Can you post your app?

To display the name, it should be as easy as:

=if(OctAppID<>AppID,[App Name],'')

Please note that in expression you have provided, the [App ID] field has a space while in your data it doesn't AppID