Match function not working when comparing and excel source to SQL

[tinkerz1]

  Hi,

I am using the function match([Table A],[Table B]), the sources of data are EXCEL and SQL, I am not getting a complete match, if I export the list boxes for Table A and Table B in excel and make a logical formala to check the cells it returns true.

As you can see the characters are the same, I have used Trim and Replace to remove spaces but still nothing. NON GENUINE: FO-FO OR FO-BO FEED ISSUE and NON GENUINE: RISK PROCESS PROBLEM don't match.

Has anyone else come across this problem?

  Table A  

GENUINE EXCESS

NON GENUINE: FO-FO OR FO-BO FEED ISSUE

NON GENUINE: MISBOOKING/ LATE BOOKING

NON GENUINE: OTHER

NON GENUINE: RISK PROCESS PROBLEM

TEMPORARY

Table B

GENUINE EXCESS

NON GENUINE: FO-FO OR FO-BO FEED ISSUE

NON GENUINE: MISBOOKING/ LATE BOOKING

NON GENUINE: OTHER

NON GENUINE: RISK PROCESS PROBLEM

TEMPORARY

Desc Table A	Formula
	-
GENUINE EXCESS	1
NON GENUINE: FO-FO OR FO-BO FEED ISSUE	-
NON GENUINE: MISBOOKING/ LATE BOOKING	1
NON GENUINE: OTHER	1
NON GENUINE: RISK PROCESS PROBLEM	-
TEMPORARY	1
-	-

[PabloOrtiz]

Hi, can you attache your .qvw?.