=IF(ISERROR(MATCH Question

[skyport]

I am using the following formula, which gives me one problem.

=IF(ISERROR(MATCH(AL1,AK:AK, 0)), "", "ALERT")

I need to be able to have some way for the solution to ignore the differences in upper and lower case between the two columns if that's possible. As an example, the entry in AL1 is exactly the same as one of the entries in column K except for words that are in caps in the one column and not in the other and that prevents the formula from recognizing the match.

Is there some way around this problem?

 

[skyport]

amazingly, that function shows it replace several instances perfectly yet it still will not do the MATCH function. A puzzle indeed

 

[Noodleski]

Works fine when I try it in your example file you posted here...

Be sure to copy paste the correct characters when using the replace all window.
I went to search for the character in the lower field in sheet 2, cell E1
The other accent which goes in the top field, come from the sheet concate, cell AK2.

 

[skyport]

One way it might be solved is if some designated column could duplicate the entries in column E (sheet 2) as the data is entered in E but without any accent marks (i.e eliminated as the data is entered automatically)

 

[skyport]

It worked this time the way you described. I must have done the copy from the formula bar instead of the cell or something, but it does work now the way you outlined in post 22

 

[skyport]

Barring any final thoughts or suggestions, I want to thank you for sticking with this and helping me with the solution from post 22. It was all greatly appreciated.

 

[Noodleski]

Happy to help, skyport.

 

[izhassan]

Happy to help, skyport.

I was glad to find this thread because I am facing the same problem. I have two columns of survey comment data that I need to compare and find a match. The issue is they are both from different files and one of them has a few comments which start with a hyphen and space and then the actual text. Is there any way that I can remove that and then use IF(ISERROR(MATCH...

 

[Noodleski]

I was glad to find this thread because I am facing the same problem. I have two columns of survey comment data that I need to compare and find a match. The issue is they are both from different files and one of them has a few comments which start with a hyphen and space and then the actual text. Is there any way that I can remove that and then use IF(ISERROR(MATCH...

Hi Izhassan,
don't know much about your file, but if the cells in the column always start with hyphen and space, you could try RIGHT(cell,LEN(cell)-2) as lookup value. (where cell is your cell reference, like A2 or something) It still depends if your values are numeric or not.

Just a tip: start a new thread with some more info on your file, problem and aim. More people will check it out and contribute.

 

[izhassan]

Hi Izhassan,
don't know much about your file, but if the cells in the column always start with hyphen and space, you could try RIGHT(cell,LEN(cell)-2) as lookup value. (where cell is your cell reference, like A2 or something) It still depends if your values are numeric or not.

Just a tip: start a new thread with some more info on your file, problem and aim. More people will check it out and contribute.

I have started a new thread, Thanks.

In relation to this thread, the following text does not match even though it is the same. Using IF(ISERROR(MATCH...

This is an honest suggestion: 1. Please remove the quota system in performance evaluation. 2. On promotion issues, I believe it is not fair. For example, I am the senior secretary (job grade 15) in our department, but until now (8 years of service), I did not get promotion. Whereas there are other secretaries in same department (3 years of service), but they got promotion. Suggestion: Serious focus on promotion matters (fairness).

Can you please tell me why? It appears in both the columns but the function does not return a match. I am using

=IF(ISERROR(MATCH(A1,$C$1:$C$3)),"","MATCH")

 

[Aladin Akyurek]

I have started a new thread, Thanks.

In relation to this thread, the following text does not match even though it is the same. Using IF(ISERROR(MATCH...

[...]

Can you please tell me why? It appears in both the columns but the function does not return a match. I am using

=IF(ISERROR(MATCH(A1,$C$1:$C$3)),"","MATCH")

What do you have exactly in A1 and in C1:C3?