COUNTIFS: Return user defined values instead of TRUE/1

[atisyam]

Hello. I am comparing 2 workbooks and checking if their respective values matches. If matches, the return value is either a TRUE or 1. However, I want the return value to be something like an alphabet. E.g. return a "P"

Below is my excel formulae:

=COUNTIFS('[TEST.xlsx]Equipment'!$A$3:$A$9,D1,'[TEST.xlsx]Equipment'!$B$3:$B$9,"TRUE")>0

Hope that what I intend is possible. If not, do advise me of other methods where I can compare 2 criterias between different workbooks and if they matches, I am able to return a user defined value. Thanks!

 

[RoryA]

You could just add an IF function:

=IF(COUNTIFS('[TEST.xlsx]Equipment'!$A$3:$A$9,D1,'[TEST.xlsx]Equipment'!$B$3:$B$9,"TRUE")>0,"P","")

 

[atisyam]

Hi Rory. Thanks, it worked!